/*
 Navicat Premium Data Transfer

 Source Server         : ncov
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : rm-wz92p9pmge2h43daabo.mysql.rds.aliyuncs.com:3306
 Source Schema         : xmpdb

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 10/03/2020 20:34:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_version
-- ----------------------------
DROP TABLE IF EXISTS `app_version`;
CREATE TABLE `app_version` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `new_version_name` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '新版本名称',
  `new_version` int(32) NOT NULL DEFAULT '1' COMMENT '最新版本号',
  `min_version` int(32) NOT NULL DEFAULT '1' COMMENT '最小支持版本号',
  `url` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '下载地址',
  `desc` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `size` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '文件大小',
  `md5` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT 'md5值',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `os_type` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'android' COMMENT 'ios  android',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='App升级管理';

-- ----------------------------
-- Records of app_version
-- ----------------------------
BEGIN;
INSERT INTO `app_version` VALUES (1, '2.0.2', 12, 1, 'https://imtt.dd.qq.com/16891/2EF04F48D3A67666DB280303081D68CF.apk', '下方的下载地址通过查看应用宝app页面的网页源码获取', '382.89K', 'dahsgua65sjgadsad', '2018-06-10 18:44:58', NULL, 'android');
INSERT INTO `app_version` VALUES (2, '1.0.0', 2, 1, ' http://p90fsuyqe.bkt.clouddn.com/20180610/fb4232adf0694af8a05daec00fcbd884.epub', '第一个版本', '10.45M', 'yihgdadad67syda', '2018-06-10 18:45:33', NULL, 'ios');
COMMIT;

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
  `chat_id` bigint(32) NOT NULL COMMENT '会话id',
  `from_uid` bigint(20) NOT NULL COMMENT '发送人id',
  `post_id` bigint(20) NOT NULL COMMENT '魔瓶id',
  `to_uid` bigint(20) NOT NULL COMMENT '接收人Id',
  `from_nick_name` varchar(150) NOT NULL,
  `to_nick_name` varchar(150) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0：正常 1：关闭  2：举报',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `handle_uid` bigint(20) DEFAULT NULL COMMENT '举报或者关闭对话人id',
  `handle_nick_name` varchar(60) DEFAULT NULL COMMENT '举报或者关闭对话人昵称',
  `to_sex` tinyint(1) DEFAULT NULL,
  `from_sex` tinyint(1) DEFAULT NULL,
  `from_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0否  1是',
  `to_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除 0否 1是',
  PRIMARY KEY (`chat_id`),
  KEY `inx_union_uid_pid` (`from_uid`,`post_id`,`to_uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of chat
-- ----------------------------
BEGIN;
INSERT INTO `chat` VALUES (-2147479103, 1068628770715344897, 1072935520524312577, 1071737788690341890, '哈喽', '嗯呐', 0, '2018-12-13 04:30:46', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147475940, 1095234070780170241, 1117570593663860738, 1094258653503954946, '夜猫子', '奈何', 0, '2019-04-15 10:13:47', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147471319, 1081827048336400385, 1097848644989734913, 1071086688815554561, '艳阳高照', '甜甜的甜甜圈', 0, '2019-02-20 11:53:46', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147451474, 1068676854518390786, 1075835048223055874, 1074606063556268033, '欧巴', 'pozzi', 0, '2018-12-21 03:58:45', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147447311, 1089918140743163906, 1086280811826651138, 1088131577147301889, '18cm', '来来来t', 0, '2019-01-30 01:42:19', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147440452, 1076379285217878018, 1076347587511984130, 1076346379166556161, '我来找你了我就是', '小小姐姐', 0, '2018-12-22 15:33:46', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147435951, 1104046072025616385, 1123034914913017858, 1121214688533700610, 'kiu', '北京大密', 0, '2019-04-30 09:30:22', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147433773, 1075584997336817665, 1084701651052273666, 1074333021521350658, '哈喽哈喽哈喽', '嘿嘿', 0, '2019-01-14 15:15:04', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147430140, 1023955641590431746, 1023953756179480577, 1023227659853729793, '里一', '重庆话文爱', 0, '2018-07-30 23:38:14', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147429504, 1077406001046495233, 1077460117907054593, 1073864100431310850, '啦咯啦咯啦咯啦啦啦', '爱美的女人', 1, '2018-12-25 15:09:52', '2018-12-25 15:09:59', 1073864100431310850, '爱美的女人', 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147422471, 1104170964331040769, 1104198981363208194, 1099858139597099010, '他，一叶倾城', '猫妹妹', 0, '2019-03-09 10:15:10', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147412538, 1089029313736482818, 1092838432528408577, 1068538022460399617, '收性奴', 'X﹏X', 0, '2019-02-06 01:33:22', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147412522, 1099941550542147586, 1115289610017058818, 1111301783365390338, '流氓的小兔', '阿吚呀', 0, '2019-04-09 00:43:36', NULL, NULL, NULL, 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147404457, 1073996263814348802, 1080826795898445826, 1079088385374560257, '注意安全', '命里有时终须有', 0, '2019-01-04 01:48:36', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147399071, 1064407706523148290, 1064429884413059074, 1049212592607846402, '卟呐呐', '月', 0, '2018-11-19 16:08:08', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147398732, 1059719315504357378, 1075704129428398082, 1066596117879201794, '反反复复呵呵人孤独的', '哒哒', 0, '2018-12-20 18:52:41', NULL, NULL, NULL, 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147397939, 1111293422762758146, 1113386457537568769, 1105252793658150913, 'yyy', '阿里山没姑娘', 1, '2019-04-03 18:25:00', '2019-04-03 18:51:59', 1105252793658150913, '阿里山没姑娘', 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147393295, 1027589230110466050, 1032541630869131265, 1030859786033315841, '蓝天白云', 'cjm', 0, '2018-08-23 16:18:52', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147390659, 1110794085821616129, 1110252614685069313, 1110326136291758081, '虐心', '么么哒＾3＾', 0, '2019-03-27 15:09:41', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147387026, 1049934672374652930, 1093858937637183490, 1089204932612988930, '小哥哥', '叶雨柔', 0, '2019-02-08 21:17:25', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147381200, 1073824055456477186, 1074204982821023746, 1026655641873178626, '桐桐', '牛力', 0, '2018-12-16 15:32:18', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147376643, 1102283220017336321, 1102443637352026113, 1095302684682080258, '咬', '幼稚小姐', 0, '2019-03-04 14:07:39', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147373424, 1115655307486310401, 1121462226444640258, 1117106441199562754, '萍萍', '小姐姐', 1, '2019-04-26 01:24:01', '2019-04-26 09:29:59', 1115655307486310401, '萍萍', 1, 2, 1, 1);
INSERT INTO `chat` VALUES (-2147371407, 1070052096243408897, 1120224559501434881, 1111912449050710018, '八', '心痛', 1, '2019-04-22 15:17:23', '2019-04-22 15:23:43', 1070052096243408897, '八', 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147370125, 1105500836974333953, 1118905592535171073, 1114437127879385090, '瘾', '妖~', 0, '2019-04-19 00:23:51', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147367597, 1040514266408538113, 1040531466683011074, 1025988840285843458, '彼岸花', '晴天', 0, '2018-09-14 17:31:59', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147366846, 1107882555207618561, 1107833164031627266, 1068538022460399617, '爱你', '肚肚～啊', 0, '2019-03-19 15:21:19', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147358382, 1044217324644704258, 1044229032499060737, 1043046465368244226, '东门先生', '子', 0, '2018-09-24 22:21:03', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147351534, 1081734623681060866, 1100658774496104450, 1057966623178113026, '哈', '参茶', 0, '2019-02-27 16:00:48', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147350213, 1042845593061310466, 1098378782978461697, 1087827082324484098, '额', '疯癫', 0, '2019-02-21 08:37:05', NULL, NULL, NULL, 1, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147346311, 1048834874334638082, 1064863503279464450, 1062748946687963138, '😍', '我毁了她一生', 0, '2018-11-21 19:04:14', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147341027, 1090281834916356097, 1120721193243009026, 1113461704865472513, '你好啊', '乐乐', 0, '2019-04-24 00:10:49', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147340136, 1103079112035045377, 1117709050646216705, 1117590323460161537, 'ha', '☀☀', 0, '2019-04-15 19:08:05', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147339282, 1074019321673433090, 1075993251766345730, 1075993026649661441, '女人有吗', 'wu女', 0, '2018-12-21 14:01:57', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147337624, 1070665682204499969, 1070705436925108226, 1070734408526340098, 'Loe1d！', '真的么', 0, '2018-12-07 01:42:19', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147334905, 1072984152103460866, 1078191243185364994, 1077559089883521025, '先生', '粘人精', 1, '2018-12-28 11:07:51', '2018-12-28 22:53:58', 1077559089883521025, '粘人精', 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147334431, 1051147113754378242, 1055856554240126978, 1043545300586831874, 'turtle', '草莓🍓', 0, '2018-10-27 00:58:51', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147331387, 1026659860768382978, 1025619312469164034, 1024191575682531330, '落云', '欲', 0, '2018-08-07 11:04:34', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147323076, 1088117984720855042, 1093784989750796290, 1092601887208775681, '少然', '他他', 0, '2019-02-08 17:20:48', NULL, NULL, NULL, 2, 2, 0, 1);
INSERT INTO `chat` VALUES (-2147304765, 1083375510496485378, 1087559541668716545, 1070626783511977985, '你好', '魔女', 0, '2019-01-22 12:01:09', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147302789, 1087732695833780226, 1088496122277666817, 1088495737798402050, '小虎牙', '溜了', 0, '2019-01-25 01:58:52', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147300824, 1075643479540899841, 1075753534487535618, 1069167557224701954, '等你下课', '帅到喷汁', 0, '2018-12-20 22:07:45', NULL, NULL, NULL, 1, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147292646, 1106928198144266242, 1110912494924238849, 1093879102378614785, '嗯哼', '跳', 0, '2019-03-27 22:45:32', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147290075, 1032804364365975554, 1039159864233938946, 1032192386480066562, 'yy', '瑁', 0, '2018-09-10 22:59:41', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147288569, 1117707147044569089, 1118533207155916802, 1088287362074550274, '獾子', '想要离骚', 0, '2019-04-17 23:36:34', NULL, NULL, NULL, 1, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147287154, 1042662261656666114, 1103287117015977986, 1096242197386350593, '饭堂', '近水楼台', 0, '2019-03-06 21:42:14', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147282683, 1027556809805684738, 1049199453254311937, 1030246702512095233, '想你了', '十月', 0, '2019-04-25 20:21:35', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147282464, 1104402624486084609, 1111255935608721410, 1084898491399938049, '啦', '玄策', 0, '2019-03-28 21:51:35', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147281878, 1098604311715368962, 1099692929389182981, 1012870983535448066, '等风来', '🐾 Val 🐘', 0, '2019-02-24 23:36:06', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147273877, 1081734623681060866, 1086184115343990785, 1085810088444174337, '佩佩', '想被ﾉ☀', 0, '2019-01-18 22:17:48', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147270605, 1083067914438844418, 1083820843907182596, 1012870983535448066, '大宝', '谢锦纯_', 0, '2019-01-12 04:22:17', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147269441, 1073124693713625090, 1109836153235738626, 1107250881130172417, '色拉想要了吗', '嘤嘤嘤i', 0, '2019-04-01 10:13:32', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147266250, 1032179980337008642, 1032478454131576834, 1032477886533193729, '渴望', '如诗如画', 0, '2018-08-23 12:16:02', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147263617, 1078529382244425730, 1079702724297105410, 1079664018974580737, '胖虎。', '咩咩', 0, '2018-12-31 19:42:27', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147261183, 1046046109547491330, 1078649267322646529, 1012870983535448066, '哈哈', '刘煜祺', 0, '2018-12-28 22:07:03', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147254026, 1084127837255901185, 1073633698835902465, 1071589464490385409, '哦咯了', '大丹丹', 0, '2019-01-13 14:38:15', NULL, NULL, NULL, 2, 2, 1, 0);
INSERT INTO `chat` VALUES (-2147249857, 1038087946248507394, 1071923537410793474, 1071401811476226049, '操你', '丽萨', 0, '2018-12-10 09:15:39', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147247283, 1122131426104336386, 1122123390740619265, 1096927282402021377, '有小哥哥在吗', '喜欢马蚤的女人', 0, '2019-04-27 21:36:01', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147242959, 1110591310944833538, 1115711260512497666, 1043499835086446594, '回不去de未成年', '呐', 0, '2019-04-10 05:16:30', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147238633, 1075397561721823234, 1080554534192816130, 1078313709278863362, '夜深了', '缕缕', 0, '2019-01-03 04:56:27', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147235419, 1076865612925378562, 1084724034869927938, 1071109590990462977, '私聊专用小马甲', '小姐姐', 0, '2019-01-14 16:09:31', NULL, NULL, NULL, 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147229301, 1102283220017336321, 1123594598023716865, 1113461704865472513, '净见i', '陈', 0, '2019-05-01 22:51:32', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147219793, 1025603667841073154, 1026636373580341249, 1012939887452581890, '大汉王爷', '吖头', 0, '2018-08-07 09:15:18', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147218584, 1107612542261301250, 1107615907099742209, 1107601508318351362, '棒', '孟', 0, '2019-03-18 20:22:28', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147215136, 1113496609301323777, 1119998623799599106, 1073143461370142721, '哥哥', '女孩001', 0, '2019-04-22 00:36:59', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147205530, 1092692042556907522, 1104418075102449665, 1101873712862449665, '大无', '浪味鲜荡', 0, '2019-03-10 00:37:22', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147198863, 1075745595328569345, 1075798154353319937, 1069970578695266306, '朋友扯会', 'GZH', 0, '2018-12-21 01:07:28', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147192396, 1063253077332701185, 1072723287865303042, 1067367501421092865, '骏', '梦', 0, '2018-12-12 15:16:42', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147187598, 1092063013839577090, 1094662281024782339, 1012870983535448066, '爸爸', '斐莘๑', 0, '2019-02-11 02:22:47', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147179831, 1073980169355542529, 1097866986366554114, 1094850790587224066, '⊙∀⊙', '偷拍裙底', 0, '2019-02-19 22:35:46', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147176308, 1099605576956104706, 1109351672179625985, 1109254008469491713, 'Mose', '找mu狗 收女奴', 0, '2019-03-23 15:16:45', NULL, NULL, NULL, 1, 2, 0, 0);
INSERT INTO `chat` VALUES (-2147174319, 1037359588321644546, 1081674305571397633, 1081670855118823425, '风逸', '污污污', 0, '2019-01-06 08:16:05', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147174278, 1103068311098265602, 1103828465011953665, 1094850790587224066, '爱晨勃的丁丁', '额', 0, '2019-03-08 17:19:31', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147171478, 1077938673573437442, 1080113466515136513, 1080112389912797186, '大鸟', '诱', 0, '2019-01-01 22:53:22', NULL, NULL, NULL, 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147166531, 1108974128699838465, 1114634682617683969, 1100035231899045889, '宝贝不哭', '浪荡Wild', 0, '2019-04-07 05:39:21', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147162682, 1025572725810348033, 1026271922100416514, 1012939887452581890, '污哥', '折折', 0, '2018-08-06 09:13:12', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147162567, 1071648635403378690, 1071672234830995457, 1071013091493289986, '嗨', '霸主', 0, '2018-12-09 15:53:14', NULL, NULL, NULL, 1, 2, 1, 0);
INSERT INTO `chat` VALUES (-2147154420, 1106193211933626369, 1123985742486331394, 1093414037707825153, '坏坏的”', '想要❤', 0, '2019-05-03 00:44:51', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147148336, 1071535072701587457, 1073636235177734145, 1012870983535448066, '哈', '女王范的我姓李 ', 0, '2018-12-15 01:52:54', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147138044, 1072905108452286466, 1109883087963066370, 1109882323991564289, '贪色散财', '。。。。', 0, '2019-03-25 22:09:24', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147135908, 1090937737743179777, 1096190581157253121, 1074429810647797762, '鸡大', '兰岚', 0, '2019-02-15 13:41:05', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147134134, 1071227467169013761, 1075620042382516225, 1066596117879201794, '一杯芝华士', '我知道是自己不自爱', 0, '2018-12-20 13:19:43', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147132002, 1086606465625497601, 1094854060588257281, 1093037989707128833, '倔强的小马甲', '未经人事的小丫头', 0, '2019-02-11 15:08:48', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147129637, 1088096762574413825, 1102955997284044802, 1098709774289195009, '！', '会游泳🏊的鱼🐠', 0, '2019-03-06 06:41:05', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147127617, 1090284773449932802, 1090437468341149697, 1077042109598408705, '机械师', '发疯的唐白河', 0, '2019-01-30 10:33:51', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147124006, 1025993071747182593, 1029707150449971202, 1029707380725649410, '在啊', '鲁鲁', 0, '2018-08-15 21:38:41', '2018-08-15 22:12:32', 1029707380725649410, '鲁鲁', 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147123904, 1115257735185707010, 1120188494723964930, 1116176296154509314, '姨', '烨烨', 0, '2019-04-22 12:52:58', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147117048, 1104046072025616385, 1104751033197826049, 1095341820172423169, 'nnj', '柠檬', 0, '2019-03-10 23:04:32', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147112630, 1107683367098290177, 1118093736673394690, 1111912449050710018, '能玩', '无聊', 0, '2019-04-16 18:39:25', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147095874, 1086270809602793474, 1086481478277144578, 1081375494387015682, '。', '半仙儿', 0, '2019-01-19 12:39:38', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147094221, 1068545291055013890, 1095211663533133825, 1088846385194737666, '路虎', '甘南~', 0, '2019-02-12 14:47:14', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147090941, 1102674839551987713, 1103689262219411457, 1012870983535448066, 'm', 'Ealrtys', 0, '2019-03-08 00:18:12', NULL, NULL, NULL, 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147088960, 1072220941200662530, 1072529586790604802, 1072350318072700929, '唉', '，', 2, '2018-12-12 00:33:44', '2018-12-12 01:19:03', 1072350318072700929, '，', 2, 1, 1, 0);
INSERT INTO `chat` VALUES (-2147085694, 1079490867435151361, 1079582947977207809, 1079579793256620034, '撸中', '妮', 0, '2018-12-31 11:42:14', NULL, NULL, NULL, 2, 1, 1, 1);
INSERT INTO `chat` VALUES (-2147082811, 1062797204126806017, 1073506821139865602, 1070626783511977985, '.嘿嘿caoyoun', '要性感不要温度', 0, '2018-12-14 17:16:39', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147081037, 1091559882840088578, 1102088039678726146, 1089171587078299649, '喜欢幼女小萝莉', '米米', 0, '2019-03-03 14:18:13', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (-2147080747, 1072303398511976450, 1110660651799318530, 1097676247711993857, '来', 'unexpected', 0, '2019-03-27 06:12:52', NULL, NULL, NULL, 2, 1, 0, 1);
INSERT INTO `chat` VALUES (-2147078879, 1089869731554402305, 1089862287147147266, 1088408465782611970, '呼哈', '有三只眼睛的兔子', 0, '2019-01-28 20:59:10', NULL, NULL, NULL, 2, 1, 0, 0);
INSERT INTO `chat` VALUES (1752686282, 1186081770891845633, 1186074518315323394, 1186066362742853633, 'CJJ', '一壶好酒', 0, '2019-10-21 08:49:06', NULL, NULL, NULL, 1, 1, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for chat_collect
-- ----------------------------
DROP TABLE IF EXISTS `chat_collect`;
CREATE TABLE `chat_collect` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `chat_id` bigint(20) NOT NULL COMMENT '会话id',
  `created_by` varchar(32) DEFAULT NULL,
  `updated_by` varchar(32) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7578 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='会话收藏表';

-- ----------------------------
-- Table structure for feed_back
-- ----------------------------
DROP TABLE IF EXISTS `feed_back`;
CREATE TABLE `feed_back` (
  `id` bigint(21) NOT NULL AUTO_INCREMENT,
  `content` varchar(1000) CHARACTER SET utf8 NOT NULL COMMENT '内容',
  `img_url` varchar(1000) CHARACTER SET utf8 DEFAULT NULL COMMENT '图片地址',
  `link` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系方式',
  `create_time` datetime NOT NULL,
  `create_by` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1077 DEFAULT CHARSET=utf8mb4 COMMENT='意见反馈';

-- ----------------------------
-- Table structure for filter_word
-- ----------------------------
DROP TABLE IF EXISTS `filter_word`;
CREATE TABLE `filter_word` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '词语内容',
  `user_id` bigint(20) NOT NULL COMMENT '创建人id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COMMENT='敏感词表';

-- ----------------------------
-- Records of filter_word
-- ----------------------------
BEGIN;
INSERT INTO `filter_word` VALUES (2, '法轮功', 1, '2018-06-03 14:49:55');
INSERT INTO `filter_word` VALUES (4, '港独', 1, '2018-06-23 00:07:01');
INSERT INTO `filter_word` VALUES (6, '一罐', 1, '2018-07-12 20:50:26');
INSERT INTO `filter_word` VALUES (7, 'APP', 1, '2018-07-12 21:25:24');
INSERT INTO `filter_word` VALUES (8, '八九学', 1, '2018-07-12 21:25:41');
INSERT INTO `filter_word` VALUES (9, '淫', 1, '2018-07-12 21:26:22');
INSERT INTO `filter_word` VALUES (10, 'http', 1, '2018-07-12 21:26:34');
INSERT INTO `filter_word` VALUES (11, '抄袭', 1, '2018-07-12 21:28:04');
INSERT INTO `filter_word` VALUES (12, '共产', 1, '2018-07-13 21:37:59');
INSERT INTO `filter_word` VALUES (15, '肉棒', 1, '2018-07-28 12:35:02');
INSERT INTO `filter_word` VALUES (17, '鸡巴', 1, '2018-07-28 18:19:21');
INSERT INTO `filter_word` VALUES (18, '约炮', 1, '2018-07-28 18:57:48');
INSERT INTO `filter_word` VALUES (19, '操逼', 1, '2018-07-28 18:59:26');
INSERT INTO `filter_word` VALUES (20, '裸聊', 1, '2018-07-28 19:03:29');
INSERT INTO `filter_word` VALUES (21, '免费资源', 1, '2018-07-28 23:13:53');
INSERT INTO `filter_word` VALUES (22, '骚逼', 1, '2018-07-29 08:26:24');
INSERT INTO `filter_word` VALUES (23, 'www', 1, '2018-07-29 12:03:20');
INSERT INTO `filter_word` VALUES (25, '口交', 1, '2018-07-30 15:07:47');
INSERT INTO `filter_word` VALUES (31, '骚货', 1, '2018-08-03 20:14:00');
INSERT INTO `filter_word` VALUES (33, '聊骚', 1, '2018-08-04 09:28:33');
INSERT INTO `filter_word` VALUES (34, '文爱', 1, '2018-08-04 14:55:25');
INSERT INTO `filter_word` VALUES (35, '撸管', 3, '2018-08-06 07:19:34');
INSERT INTO `filter_word` VALUES (36, '阴茎', 3, '2018-08-06 09:39:24');
INSERT INTO `filter_word` VALUES (37, '机器人', 1, '2018-08-06 18:54:18');
INSERT INTO `filter_word` VALUES (40, '习近平', 4, '2018-08-06 22:53:03');
INSERT INTO `filter_word` VALUES (41, '江泽民', 4, '2018-08-06 22:58:38');
INSERT INTO `filter_word` VALUES (42, '福利', 1, '2018-08-09 08:42:52');
INSERT INTO `filter_word` VALUES (43, '兼职', 3, '2018-08-10 08:46:15');
INSERT INTO `filter_word` VALUES (44, '公众号', 1, '2018-08-10 13:26:03');
INSERT INTO `filter_word` VALUES (45, '加V', 1, '2018-08-11 10:33:22');
INSERT INTO `filter_word` VALUES (47, '互图', 1, '2018-08-11 20:44:45');
INSERT INTO `filter_word` VALUES (48, '找我聊聊', 1, '2018-08-12 10:52:45');
INSERT INTO `filter_word` VALUES (49, '调教', 1, '2018-08-12 16:55:41');
INSERT INTO `filter_word` VALUES (68, '台独', 1, '2018-08-18 08:09:59');
INSERT INTO `filter_word` VALUES (70, '优惠券', 1, '2018-08-19 10:42:21');
INSERT INTO `filter_word` VALUES (71, '加我微信', 3, '2018-08-19 15:47:21');
INSERT INTO `filter_word` VALUES (72, '鸡鸡', 1, '2018-08-20 08:07:08');
INSERT INTO `filter_word` VALUES (73, '硬邦邦', 3, '2018-08-23 17:33:27');
INSERT INTO `filter_word` VALUES (75, 'JB', 1, '2018-08-24 22:24:57');
INSERT INTO `filter_word` VALUES (76, '官方', 1, '2018-08-26 07:48:25');
INSERT INTO `filter_word` VALUES (78, '有小姐姐', 1, '2018-08-26 07:48:55');
INSERT INTO `filter_word` VALUES (79, '免费加入', 1, '2018-08-26 08:14:58');
INSERT INTO `filter_word` VALUES (81, '骚穴', 3, '2018-09-01 09:08:38');
INSERT INTO `filter_word` VALUES (83, '爆菊', 3, '2018-09-03 09:32:11');
INSERT INTO `filter_word` VALUES (84, 'qq群', 1, '2018-09-05 00:44:42');
INSERT INTO `filter_word` VALUES (85, '撩骚', 3, '2018-09-05 09:57:19');
INSERT INTO `filter_word` VALUES (86, '佣金', 3, '2018-09-08 16:02:06');
INSERT INTO `filter_word` VALUES (87, '网调', 3, '2018-09-08 16:06:23');
INSERT INTO `filter_word` VALUES (88, '马眼', 3, '2018-09-08 22:38:44');
INSERT INTO `filter_word` VALUES (89, '精液', 3, '2018-09-08 22:39:11');
INSERT INTO `filter_word` VALUES (90, '肛交', 3, '2018-09-08 22:40:43');
INSERT INTO `filter_word` VALUES (91, '小穴', 3, '2018-09-09 20:04:34');
INSERT INTO `filter_word` VALUES (92, '龟头', 3, '2018-09-13 09:31:10');
INSERT INTO `filter_word` VALUES (93, '屁眼', 3, '2018-09-19 15:19:38');
INSERT INTO `filter_word` VALUES (95, '炮友', 1, '2018-09-21 07:31:09');
INSERT INTO `filter_word` VALUES (96, '污群', 3, '2018-09-25 17:28:49');
INSERT INTO `filter_word` VALUES (97, '网赚', 3, '2018-10-07 14:30:34');
INSERT INTO `filter_word` VALUES (99, '阴道', 3, '2018-10-08 09:24:26');
INSERT INTO `filter_word` VALUES (100, '字母圈', 3, '2018-10-12 09:41:23');
INSERT INTO `filter_word` VALUES (101, '母狗', 3, '2018-10-13 21:34:43');
INSERT INTO `filter_word` VALUES (102, '有没有', 3, '2018-10-15 23:02:51');
INSERT INTO `filter_word` VALUES (103, '乱伦', 3, '2018-10-31 17:49:17');
INSERT INTO `filter_word` VALUES (104, '肉洞', 3, '2018-11-10 13:16:19');
INSERT INTO `filter_word` VALUES (105, '约吗', 3, '2018-11-10 19:16:52');
INSERT INTO `filter_word` VALUES (106, '鸡吧', 3, '2018-12-06 20:37:19');
INSERT INTO `filter_word` VALUES (108, '加微信', 1, '2018-12-13 11:38:01');
INSERT INTO `filter_word` VALUES (109, '加我微信', 1, '2018-12-13 11:38:08');
INSERT INTO `filter_word` VALUES (111, '扣扣', 1, '2018-12-13 11:40:27');
INSERT INTO `filter_word` VALUES (112, '聊污', 3, '2018-12-13 22:33:24');
INSERT INTO `filter_word` VALUES (113, '乖女儿', 3, '2018-12-14 11:10:12');
INSERT INTO `filter_word` VALUES (115, '熟女', 1, '2018-12-15 16:51:13');
INSERT INTO `filter_word` VALUES (117, '任务', 1, '2018-12-16 02:06:43');
INSERT INTO `filter_word` VALUES (122, '好寂寞', 1, '2018-12-16 11:54:09');
INSERT INTO `filter_word` VALUES (130, '有偿', 1, '2018-12-16 23:51:13');
INSERT INTO `filter_word` VALUES (131, '反差婊', 3, '2018-12-20 16:03:40');
INSERT INTO `filter_word` VALUES (132, '阴蒂', 3, '2018-12-23 14:14:42');
INSERT INTO `filter_word` VALUES (133, '主人', 3, '2018-12-28 13:44:52');
INSERT INTO `filter_word` VALUES (134, '叫爸爸', 3, '2019-01-02 19:37:46');
INSERT INTO `filter_word` VALUES (135, 'wu群', 3, '2019-02-02 20:16:47');
INSERT INTO `filter_word` VALUES (136, '软件', 1, '2019-02-12 22:57:18');
INSERT INTO `filter_word` VALUES (137, '小电影', 1, '2019-02-12 22:57:36');
INSERT INTO `filter_word` VALUES (138, '私我', 1, '2019-02-12 22:57:53');
INSERT INTO `filter_word` VALUES (139, '骚', 1, '2019-03-30 22:13:07');
INSERT INTO `filter_word` VALUES (140, '老婆', 1, '2019-03-30 22:13:14');
INSERT INTO `filter_word` VALUES (141, '人妻', 1, '2019-03-30 22:13:20');
INSERT INTO `filter_word` VALUES (142, '电影', 1, '2019-03-30 22:14:04');
INSERT INTO `filter_word` VALUES (143, '做爱', 1, '2019-03-30 22:15:13');
INSERT INTO `filter_word` VALUES (144, '内裤', 1, '2019-03-30 22:15:21');
INSERT INTO `filter_word` VALUES (145, '扣', 1, '2019-03-30 22:15:50');
INSERT INTO `filter_word` VALUES (146, '污', 1, '2019-03-30 22:16:18');
INSERT INTO `filter_word` VALUES (147, '啪啪', 1, '2019-03-30 22:17:49');
INSERT INTO `filter_word` VALUES (148, '偷情', 1, '2019-03-30 22:17:59');
INSERT INTO `filter_word` VALUES (149, '小视频', 1, '2019-03-30 22:19:51');
INSERT INTO `filter_word` VALUES (150, '私聊', 1, '2019-03-31 21:55:44');
INSERT INTO `filter_word` VALUES (151, '乳房', 1, '2019-03-31 21:55:50');
INSERT INTO `filter_word` VALUES (152, '粗', 1, '2019-03-31 21:56:03');
INSERT INTO `filter_word` VALUES (153, '硬', 1, '2019-03-31 21:56:10');
INSERT INTO `filter_word` VALUES (154, '寂寞', 1, '2019-03-31 22:04:28');
INSERT INTO `filter_word` VALUES (155, '处女', 1, '2019-03-31 22:04:46');
INSERT INTO `filter_word` VALUES (156, '处男', 1, '2019-03-31 22:04:55');
INSERT INTO `filter_word` VALUES (157, '性欲', 1, '2019-03-31 22:08:12');
INSERT INTO `filter_word` VALUES (158, '偷情', 1, '2019-03-31 22:08:23');
INSERT INTO `filter_word` VALUES (159, '野战', 1, '2019-03-31 22:10:02');
INSERT INTO `filter_word` VALUES (160, '内裤', 1, '2019-03-31 22:10:24');
INSERT INTO `filter_word` VALUES (161, '春药', 1, '2019-04-03 20:25:38');
INSERT INTO `filter_word` VALUES (162, '高潮', 1, '2019-04-03 20:25:45');
INSERT INTO `filter_word` VALUES (163, '强奸', 1, '2019-04-03 20:25:50');
INSERT INTO `filter_word` VALUES (164, '微信', 1, '2019-04-03 20:26:18');
INSERT INTO `filter_word` VALUES (165, 'QQ', 1, '2019-04-03 20:26:30');
INSERT INTO `filter_word` VALUES (166, '舔', 1, '2019-04-03 20:39:56');
INSERT INTO `filter_word` VALUES (167, '性', 1, '2019-04-04 21:55:33');
INSERT INTO `filter_word` VALUES (168, '自慰', 1, '2019-04-04 21:55:41');
INSERT INTO `filter_word` VALUES (169, '代理', 1, '2019-04-04 21:57:40');
INSERT INTO `filter_word` VALUES (170, '乱轮', 1, '2019-04-04 22:01:49');
INSERT INTO `filter_word` VALUES (171, '呻吟', 1, '2019-04-06 13:25:31');
INSERT INTO `filter_word` VALUES (172, '内射', 1, '2019-04-06 13:25:41');
INSERT INTO `filter_word` VALUES (173, '后入', 1, '2019-04-06 13:25:47');
INSERT INTO `filter_word` VALUES (174, '3p', 1, '2019-04-13 19:44:11');
INSERT INTO `filter_word` VALUES (175, '精子', 1, '2019-04-13 19:44:24');
INSERT INTO `filter_word` VALUES (176, '跳蛋', 1, '2019-04-13 19:44:40');
INSERT INTO `filter_word` VALUES (177, '私处', 1, '2019-04-13 19:46:13');
INSERT INTO `filter_word` VALUES (178, '少妇', 1, '2019-04-13 19:48:32');
INSERT INTO `filter_word` VALUES (179, '乳头', 1, '2019-04-13 19:48:52');
INSERT INTO `filter_word` VALUES (180, '免费', 1, '2019-04-13 19:51:30');
COMMIT;

-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `open_id` varchar(32) CHARACTER SET utf8 NOT NULL,
  `idfa` varchar(120) CHARACTER SET utf8 DEFAULT NULL,
  `ua` varchar(120) CHARACTER SET utf8 DEFAULT NULL,
  `mobile_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `mobile_version` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `imei` varchar(120) CHARACTER SET utf8 DEFAULT NULL,
  `source_type` tinyint(1) DEFAULT '1' COMMENT '来源 1：ios  2:andriod',
  `login_type` tinyint(1) DEFAULT '1' COMMENT '登录方式 1：微信 2:QQ',
  `jpush_id` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `ip` varchar(160) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1905463 DEFAULT CHARSET=utf8mb4 COMMENT='登陆日志表';

-- ----------------------------
-- Records of login_log
-- ----------------------------
BEGIN;
INSERT INTO `login_log` VALUES (1905452, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 2, '120c83f7604c768acf2', '2019-10-21 07:47:12', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905453, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 08:16:25', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905454, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 08:22:41', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905455, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 08:36:48', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905456, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 08:36:54', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905457, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 08:37:23', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905458, 1186081770891845633, '32F5776C3EAE42AAE5B0F76B57C0B109', NULL, NULL, 'Xiaomi Mi Note 3', '8.1.0', '865499032821744', 2, 1, '18071adc03798b0e29f', '2019-10-21 08:48:25', '223.104.66.119');
INSERT INTO `login_log` VALUES (1905459, 1186081770891845633, '32F5776C3EAE42AAE5B0F76B57C0B109', NULL, NULL, 'Xiaomi Mi Note 3', '8.1.0', '865499032821744', 2, 1, '18071adc03798b0e29f', '2019-10-21 08:51:31', '223.104.66.119');
INSERT INTO `login_log` VALUES (1905460, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 09:51:56', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905461, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 09:53:31', '223.104.66.99');
INSERT INTO `login_log` VALUES (1905462, 1186066362742853633, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', NULL, NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, 1, '120c83f7604c768acf2', '2019-10-21 10:22:20', '223.104.66.99');
COMMIT;

-- ----------------------------
-- Table structure for magic_user
-- ----------------------------
DROP TABLE IF EXISTS `magic_user`;
CREATE TABLE `magic_user` (
  `id` bigint(20) NOT NULL,
  `nick_name` varchar(150) DEFAULT NULL COMMENT '用户昵称',
  `last_login_ip` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '最后一次登录ip地址',
  `sex` tinyint(1) DEFAULT '3' COMMENT '性别 1：男 2：女 3：未知',
  `idfa` varchar(120) CHARACTER SET utf8 DEFAULT '' COMMENT 'idfa',
  `ua` varchar(120) CHARACTER SET utf8 DEFAULT NULL COMMENT 'ua',
  `mobile_name` varchar(32) CHARACTER SET utf8 DEFAULT '' COMMENT '手机名称',
  `mobile_version` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机型号',
  `imei` varchar(120) CHARACTER SET utf8 DEFAULT NULL COMMENT 'imei',
  `source_type` tinyint(1) DEFAULT '1' COMMENT '来源 1：ios  2:andriod ',
  `age` varchar(16) CHARACTER SET utf8 DEFAULT '' COMMENT '年龄描述',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `password` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '密码',
  `login_type` tinyint(1) DEFAULT '1' COMMENT '登录方式 1：微信 2:QQ',
  `jpush_id` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '极光推送id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `deleted` tinyint(1) DEFAULT '1' COMMENT '是否删除 1：否 2：是',
  `open_id` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '微信openId',
  `status` int(11) DEFAULT '1' COMMENT '1：正常 2：禁言',
  `device_status` bigint(1) NOT NULL DEFAULT '1' COMMENT '设备禁言状态 1正常 2禁言',
  PRIMARY KEY (`id`),
  UNIQUE KEY `nick_name` (`nick_name`),
  UNIQUE KEY `open_id_index` (`open_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of magic_user
-- ----------------------------
BEGIN;
INSERT INTO `magic_user` VALUES (1012784423909650434, '微信10', '116.24.80.13', 1, '5899FAA2-E471-447B-AAC3-FD9F0381C294', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15F79', '港行、国行iPhone 7 Plus', '11.4', 'CEFB3D8D-D4BC-4E57-AF57-C677A3974FC7', 1, '90后', '2018-08-15 13:03:55', NULL, 1, '1a1018970af2eade81d', '2018-06-30 03:46:38', 1, 'oyZVQ1kbh43ftcwh8yi6TXz4YTPU', 1, 1);
INSERT INTO `magic_user` VALUES (1012786172036837378, '学霸', '183.50.203.95', 2, '', NULL, 'YOTA Y3', '7.1.1', '352341090575350', 2, '80前', '2018-11-26 12:52:06', NULL, 1, '100d8559096f8499494', '2018-06-30 03:53:35', 1, '8A4E79AE2BD9E3D6CD74361C10BAE52E', 1, 1);
INSERT INTO `magic_user` VALUES (1012833011595407362, '女司机', '14.103.111.140', 1, '', NULL, 'Xiaomi MI 6 ', '4.4.2', '863064010481382', 2, '00后', '2018-08-04 20:12:49', NULL, 1, '160a3797c857e411f2d', '2018-06-30 06:59:42', 1, '2E532F0B403C4B05CC4B4DE6AECB22D4', 1, 1);
INSERT INTO `magic_user` VALUES (1012867963338813442, '哇哈', '119.137.54.219', 1, '5A56642A-F9B8-483D-B566-495554E6F8DE', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_1_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16D57', 'iPhone11,8', '12.1.4', 'A9A250B9-C12F-48CF-BFB0-D162CB912C31', 1, '90后', '2019-04-05 21:01:43', NULL, 1, '1517bfd3f79fc301ba4', '2018-06-30 09:18:35', 1, 'oyZVQ1kvECO2zYPqvrfqZdaZ-zKM', 1, 1);
INSERT INTO `magic_user` VALUES (1012870289281667073, '慕容白', '223.104.63.4', 1, 'D412E147-CA09-4D5C-86B1-B414360DE70F', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77', 'HONOR DUK-AL20', '8.0.0', '866049033710591', 2, '85后', '2019-01-08 12:53:17', NULL, 1, '1507bfd3f7902fe42a6', '2018-06-30 09:27:50', 1, 'A7BFFC22D21D06594B2533B53CE22C5F', 1, 1);
INSERT INTO `magic_user` VALUES (1012870983535448066, '阿雅', '120.229.79.130', 2, 'D412E147-CA09-4D5C-86B1-B414360DE70F', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_2_1 like Mac OS X) AppleWebKit/604.4.7 (KHTML, like Gecko) Mobile/15C153', 'HONOR DUK-AL20', '8.0.0', '866049033710591', 2, '不告诉你', '2018-11-18 18:48:38', NULL, 1, '140fe1da9efb5c2cf8b', '2018-06-30 09:30:35', 1, '4181CE3D7E886008AA8D474413D50716', 1, 1);
INSERT INTO `magic_user` VALUES (1012878480845500418, '南方姑娘', '120.229.79.29', 2, 'D412E147-CA09-4D5C-86B1-B414360DE70F', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77', 'HONOR DUK-AL20', '8.0.0', '866049033710591', 2, '90后', '2019-03-31 21:26:22', NULL, 2, '1104a89792eb82c858d', '2018-06-30 10:00:23', 1, 'oyZVQ1kMWTBIt9AgceOelGHf7NO0', 1, 1);
INSERT INTO `magic_user` VALUES (1012901580446285826, '微信20', '223.149.242.178', 2, 'CA0C8836-909A-4AC9-AE0E-BC38515F5079', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16C101', 'iPhone 6', '12.1.2', 'A52DCE14-0BE2-47B2-B74C-B31D78919153', 1, '95后', '2019-02-16 13:49:22', NULL, 1, '171976fa8ac4ed66124', '2018-06-30 11:32:10', 1, 'oyZVQ1kg3hsqNi5ACQeJHr6UPLcY', 1, 2);
INSERT INTO `magic_user` VALUES (1012939847141126145, '孤独不败', '112.97.59.47', 1, '655CE7D5-1429-42BF-BEF1-E67AD08C1451', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16C101', 'iPhone 6', '12.1.2', '7FB254B0-BD64-46E6-B4EA-E6DFDEB0230F', 1, '95后', '2019-01-02 07:20:03', NULL, 2, '1114a8979280ecad483', '2018-06-30 14:04:14', 1, '07E3EFEEEC31D0D8A0F6036AF46F0AE9', 1, 1);
INSERT INTO `magic_user` VALUES (1012939887452581890, '大神', '27.38.241.28', 2, '655CE7D5-1429-42BF-BEF1-E67AD08C1451', 'Mozilla/5.0 (iPhone; CPU iPhone OS 12_1_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16C101', 'iPhone 6', '12.1.2', '7FB254B0-BD64-46E6-B4EA-E6DFDEB0230F', 1, '85后', '2019-01-02 07:15:49', NULL, 1, '1114a8979280ecad483', '2018-06-30 14:04:23', 1, 'oyZVQ1mqMGKfXhJH7ayK6hRRK2RE', 1, 1);
INSERT INTO `magic_user` VALUES (1012956668326014977, '妮妮', '120.229.79.152', 2, 'D412E147-CA09-4D5C-86B1-B414360DE70F', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77', 'HONOR DUK-AL20', '8.0.0', '866049033710591', 2, '90后', '2019-05-03 22:58:23', NULL, 1, '1104a89792eb82c858d', '2018-06-30 15:11:04', 1, 'oyZVQ1hjrQQb-Td1idVDYFumcyh8', 1, 1);
INSERT INTO `magic_user` VALUES (1012962325057990657, '小魔瓶管理员', '117.136.79.143', 1, 'D412E147-CA09-4D5C-86B1-B414360DE70F', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_2_1 like Mac OS X) AppleWebKit/604.4.7 (KHTML, like Gecko) Mobile/15C153', 'HONOR DUK-AL20', '8.0.0', '866049033710591', 2, '85后', '2018-12-06 10:41:21', NULL, 2, '1507bfd3f7902fe42a6', '2018-07-01 15:33:33', 1, '4722521549455054EBBE115E097C00CD', 1, 1);
INSERT INTO `magic_user` VALUES (1017372125573373954, '加油', '223.104.63.36', 1, '', NULL, 'HONOR PRA-AL00X', '7.0', '862859039258310', 2, '00后', '2018-07-12 19:36:31', NULL, 1, '1104a89792f8517b1d4', '2018-07-12 19:36:31', 1, '345CDD3A10B63EAB1C8239AB9DCCA6FA', 1, 1);
INSERT INTO `magic_user` VALUES (1017376287602204674, '安', '120.202.26.95', 1, '', NULL, 'HONOR COR-AL10', '8.1.0', '869838043250904', 2, '80后', '2018-12-14 08:47:19', NULL, 2, '1104a89792f0fa8a707', '2018-07-12 19:53:04', 1, 'oyZVQ1qYFAPLIGkDaIq4wUWlfuMk', 1, 1);
INSERT INTO `magic_user` VALUES (1017389002026606593, '🍀', '182.127.192.91', 2, '', NULL, 'vivo vivo X21A', '8.1.0', '869019032086878', 2, '95后', '2019-02-08 22:48:15', NULL, 1, '1a0018970af77c61ffd', '2018-07-12 20:43:35', 1, '23FB4FC34EC757144DDF0BD042D13B1F', 1, 1);
INSERT INTO `magic_user` VALUES (1017396355904004097, 'iii', '112.11.66.83', 1, '', NULL, 'vivo vivo X7', '5.1.1', '862341036487069', 2, '95后', '2018-07-12 21:12:48', NULL, 1, '1507bfd3f7969a23c70', '2018-07-12 21:12:48', 1, '1F2AFF74FFE7B73C9209C8C97C58C388', 1, 1);
INSERT INTO `magic_user` VALUES (1017415027448045569, '七白', '219.233.34.189', 2, '', NULL, 'vivo vivo X21A', '8.1.0', '868452034703276', 2, '00后', '2018-07-12 22:27:00', NULL, 1, '120c83f76075d7fffcd', '2018-07-12 22:27:00', 1, '0792E3BAB93AE6F698955D8217B5DF95', 1, 1);
INSERT INTO `magic_user` VALUES (1017449900372082690, '咿呀咿呀哟', '36.149.45.102', 1, '', NULL, '360 1605-A01', '7.1.1', NULL, 2, '不告诉你', '2018-07-13 00:45:34', NULL, 1, '190e35f7e0147f184ad', '2018-07-13 00:45:34', 1, '698CCEC49A3B1E905910EE8677EF5ADC', 1, 1);
INSERT INTO `magic_user` VALUES (1019199990384275457, '啦啦', '117.154.223.228', 2, '', NULL, 'HONOR COL-AL10', '8.1.0', '869384038896948', 2, '90后', '2018-07-28 16:05:11', NULL, 1, '100d8559091189c875b', '2018-07-17 20:39:48', 1, '5EED47193042253C8B5071F6F6261615', 1, 1);
INSERT INTO `magic_user` VALUES (1019211841218260994, '天气先生', '183.205.2.54', 1, '', NULL, 'vivo vivo X20Plus A', '7.1.1', '867476036314270', 2, '90后', '2018-12-29 01:38:37', NULL, 2, '170976fa8ad63f00a65', '2018-07-17 21:26:54', 1, 'oyZVQ1m4vs8_1J5rMr-appDAM3_s', 1, 1);
INSERT INTO `magic_user` VALUES (1019265398571249666, '文爱', '222.221.166.89', 1, '', NULL, 'vivo vivo X9i', '6.0.1', '864534037672220', 2, '不告诉你', '2018-07-18 00:59:43', NULL, 1, '1104a89792fff8fb3bd', '2018-07-18 00:59:43', 1, '582FADF8E067C74530BD6D6999B10472', 1, 1);
INSERT INTO `magic_user` VALUES (1019389839733141506, '呵呵', '223.104.13.202', 2, '', NULL, 'vivo vivo X21A', '8.1.0', '869939038556956', 2, '00后', '2018-07-18 09:14:12', NULL, 1, '100d855909118ea09f6', '2018-07-18 09:14:12', 1, '5D70870356909E78047A571149459843', 1, 1);
INSERT INTO `magic_user` VALUES (1019525429728358401, '我还是一个宝宝', '139.207.49.227', 2, '', NULL, 'asus ASUS_X008', '6.0', '99000823107524', 2, '00后', '2018-07-18 18:12:59', NULL, 1, '1104a89792ffed3b22b', '2018-07-18 18:12:59', 1, '8D7FB062A146EC40F29495A02E0A3A75', 1, 1);
INSERT INTO `magic_user` VALUES (1024299388232613890, '奶思', '222.90.42.113', 2, '', NULL, 'vivo vivo Y85A', '8.1.0', '865159043784923', 2, '00后', '2018-07-31 23:56:45', NULL, 1, '18071adc035a91618b6', '2018-07-31 22:22:59', 1, 'E6B4DAD31F855B758D8A6DD733242680', 1, 1);
INSERT INTO `magic_user` VALUES (1024300172970115074, '大浪淘沙', '112.20.107.131', 1, '2EEF6F1E-C974-455F-805C-41BD99D4F416', 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/13G36', 'iPhone 6s', '9.3.5', '21A73113-7526-48CD-9556-BD1E153908B9', 1, '90后', '2018-07-31 22:26:06', NULL, 2, '1a1018970af1f35ccc9', '2018-07-31 22:26:06', 1, '34459CCA00EF301BA51A27F53162C32E', 1, 1);
INSERT INTO `magic_user` VALUES (1024300951244193793, '✌🏻', '180.130.10.29', 1, '85E4A77F-FEFF-4979-95D8-83E6D29B82E6', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E216', '国行、日版、港行iPhone 7', '11.3', '70CD3B8B-C268-45A6-8C9F-F822222B9AA5', 1, '95后', '2018-07-31 22:29:12', NULL, 1, '101d85590910a86abb8', '2018-07-31 22:29:12', 1, 'oyZVQ1nBHNBrgNZhRMFKpcuK_aM4', 1, 1);
INSERT INTO `magic_user` VALUES (1024301408716931073, '你的室友是男的吗', '222.42.121.103', 1, '9972CE79-9719-457E-ADEB-BF9E5E5952D9', 'Mozilla/5.0 (iPhone; CPU iPhone OS 11_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15F79', 'iPhone_8_Plus', '11.4', 'D5C80715-FE55-4EC4-8D24-102A8C37603B', 1, '80后', '2018-07-31 22:31:01', NULL, 1, '161a3797c853d8d5aa8', '2018-07-31 22:31:01', 1, 'oyZVQ1irwMoh2AQbdchfH5TWl-tk', 1, 1);
INSERT INTO `magic_user` VALUES (1024303839752306689, 'Whale', '112.19.186.231', 2, '', NULL, 'vivo vivo X5S L', '4.4.4', '866825021249092', 2, '95后', '2018-07-31 22:40:41', NULL, 2, '1104a89792fedd12470', '2018-07-31 22:40:41', 1, 'oyZVQ1r0v-wFCSKHURJkH0UoW6m4', 1, 1);
INSERT INTO `magic_user` VALUES (1024305646339702785, '白歌', '42.229.78.210', 2, '', NULL, 'HUAWEI HUAWEI GRA-TL00', '5.0.1', '869511020842650', 2, '00后', '2019-02-13 18:57:13', NULL, 1, '1507bfd3f790171b7b2', '2018-07-31 22:47:51', 1, 'ED4444B30C98E45B5C41F4A40F7A937B', 1, 1);
INSERT INTO `magic_user` VALUES (1186066362742853633, NULL, '223.104.66.99', 1, '', NULL, 'HUAWEI GLK-AL00', '9', '861520042515929', 2, '80后', '2019-10-21 08:16:25', NULL, 2, '120c83f7604c768acf2', '2019-10-21 07:47:12', 1, 'oyZVQ1rTvy9ny4664T-zksfNx7oI', 1, 1);
INSERT INTO `magic_user` VALUES (1186081770891845633, '吃', '223.104.66.119', 1, '', NULL, 'Xiaomi Mi Note 3', '8.1.0', '865499032821744', 2, '90后', '2019-10-21 08:48:25', NULL, 1, '18071adc03798b0e29f', '2019-10-21 08:48:25', 1, '32F5776C3EAE42AAE5B0F76B57C0B109', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `msg_id` bigint(20) NOT NULL,
  `chat_id` bigint(20) DEFAULT NULL COMMENT '会话id',
  `post_id` bigint(20) DEFAULT NULL COMMENT '魔瓶id',
  `from_uid` bigint(20) NOT NULL COMMENT '发送者id',
  `to_uid` bigint(20) NOT NULL COMMENT '接收者id',
  `from_nick_name` varchar(150) DEFAULT NULL COMMENT '发送者昵称',
  `to_nick_name` varchar(150) DEFAULT NULL COMMENT '接收者昵称',
  `msg_type` int(10) NOT NULL DEFAULT '1' COMMENT '1 文字 2图片 3评论通知  4点赞通知  5会话关闭  6会话举报 7会话开启  8禁言提醒 9不同设备登陆通知 10禁言通知',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态 0：未发送  1：已发送',
  `content` varchar(500) NOT NULL COMMENT '消息内容',
  `shield_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否屏蔽 0否 1是',
  `image_url` varchar(500) DEFAULT NULL COMMENT '图片地址',
  `jpush_id` varchar(32) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `tag_name` varchar(32) DEFAULT NULL COMMENT '帖子标签昵称',
  `from_sex` tinyint(1) DEFAULT NULL COMMENT '发送人性别',
  `to_sex` tinyint(1) DEFAULT NULL COMMENT '接收人性别',
  PRIMARY KEY (`msg_id`),
  KEY `idx_from_uid` (`from_uid`) USING BTREE,
  KEY `idx_to_uid` (`to_uid`) USING BTREE,
  KEY `idx_chat_id` (`chat_id`) USING BTREE,
  KEY `idx_post_id` (`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='消息表';

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES (1186081944141766658, 1752686282, 1186074518315323394, 1186081770891845633, 1186066362742853633, 'CJJ', '一壶好酒', 1, 1, '来了', 0, NULL, '120c83f7604c768acf2', '2019-10-21 08:49:55', '2019-10-21 08:49:06', '此刻', 1, 1);
INSERT INTO `message` VALUES (1186082217245483009, 1752686282, 1186074518315323394, 1186066362742853633, 1186081770891845633, '一壶好酒', 'CJJ', 1, 1, '收到了', 0, NULL, '18071adc03798b0e29f', '2019-10-21 08:50:12', '2019-10-21 08:50:12', '此刻', 1, 1);
INSERT INTO `message` VALUES (1186082423823343617, NULL, 1186074518315323394, 1186081770891845633, 1186066362742853633, NULL, NULL, 4, 1, '今天天气不错，整个人都充满了活力，早上起来又一个美好的一天开始了。', 0, NULL, '120c83f7604c768acf2', '2019-10-21 09:09:33', '2019-10-21 08:51:01', '此刻', NULL, NULL);
INSERT INTO `message` VALUES (1186082515502440449, NULL, 1186074518315323394, 1186081770891845633, 1186066362742853633, '吃', NULL, 3, 1, '今天天气不错，整个人都充满了活力，早上起来又一个美好的一天开始了。', 0, NULL, '120c83f7604c768acf2', '2019-10-21 09:09:33', '2019-10-21 08:51:23', '此刻', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for post
-- ----------------------------
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
  `id` bigint(20) NOT NULL,
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `week` varchar(255) DEFAULT NULL COMMENT '星期',
  `nick_name` varchar(100) DEFAULT NULL COMMENT '昵称',
  `temperature` varchar(16) DEFAULT NULL COMMENT '温度',
  `weather` varchar(16) DEFAULT NULL COMMENT '天气',
  `publish_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发布状态 0：未发布 1：已发布',
  `shield_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '屏蔽状态 0：未屏蔽 1：已屏蔽',
  `comment_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可以评论 0：是 1：否',
  `tag_id` bigint(20) NOT NULL DEFAULT '-1' COMMENT '标签id',
  `tag_name` varchar(16) NOT NULL DEFAULT '此刻' COMMENT '标签名称',
  `comment_count` bigint(20) NOT NULL DEFAULT '0' COMMENT '评论数量',
  `like_count` bigint(20) NOT NULL DEFAULT '0' COMMENT '点赞数量',
  `images` varchar(1000) DEFAULT NULL COMMENT '图片，多张逗号隔开',
  `sex` tinyint(1) NOT NULL DEFAULT '1' COMMENT '性别 1：男 2：女',
  `content` text NOT NULL COMMENT '内容',
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `link_url` varchar(200) DEFAULT NULL COMMENT '置顶帖子广告链接',
  `os_type` tinyint(4) DEFAULT '0' COMMENT '置顶帖子 0：不置顶 1:ios,2:android',
  `topic_id` bigint(20) DEFAULT NULL COMMENT '话题id',
  `topic_name` varchar(50) DEFAULT NULL COMMENT '话题内容',
  PRIMARY KEY (`id`),
  KEY `user_id_index` (`user_id`) USING BTREE,
  KEY `tag_id_index` (`tag_id`) USING BTREE,
  KEY `idx_ss` (`shield_status`) USING BTREE,
  KEY `idx_ps` (`publish_status`) USING BTREE,
  KEY `idx_del` (`deleted`) USING BTREE,
  KEY `idx_create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='帖子（魔瓶表）';

-- ----------------------------
-- Records of post
-- ----------------------------
BEGIN;
INSERT INTO `post` VALUES (1014133730839609345, NULL, 1012956668326014977, '星期二', '小苹果🍎', '31℃', '阴', 1, 0, 0, -1, '此刻', 2, 3, '[\"http://img.shaiquan.net/1530623297/0/611X356\",\"http://img.shaiquan.net/1530623297/2/640X400\",\"http://img.shaiquan.net/1530623297/1/640X426\"]', 2, '美丽的风景在路上，此刻我在阳朔😎😎', '2018-07-03 21:08:18', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014134788655661057, NULL, 1012956668326014977, '星期二', '我爱梅西', '31℃', '阴', 1, 0, 0, 2, '美食', 2, 3, '[\"http://img.shaiquan.net/1530623549/0/828X620\"]', 2, '香蜜湖，冰凉爽口的啤酒🍻和小龙虾走起，吃完一起看世界杯，今晚瑞士打瑞典，你买谁赢？', '2018-07-03 21:12:30', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014135916508200962, NULL, 1012870289281667073, '星期二', '我不是学霸', '31℃', '阴', 1, 0, 0, 3, '开心', 13, 3, NULL, 1, '高考分数线出来了，考了690分，比我预估的少了10分，我终于可以和她一起走进梦寐以求的清华了，开心😀', '2018-07-03 21:16:59', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014136542893948929, NULL, 1012870289281667073, '星期二', '友缘人', '31℃', '阴', 1, 0, 0, 5, '失眠', 3, 5, NULL, 1, '总是在一个失眠的夜\n我就会盼望你的出现\n你有美丽温柔的双眼\n我可以看见\n就是在一个这样的夜\n我就会对你特别思念\n我愿意抛开身边所有的一切\n爱你多些', '2018-07-03 21:19:28', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014137447391412226, NULL, 1012956668326014977, '星期二', '漂洋过海来看你', '31℃', '阴', 1, 0, 1, 1, '丧', 0, 4, '[\"http://img.shaiquan.net/1530624183/0/814X505\"]', 2, '我好像找个人说话，可是好像没有人适合听。常常来来去去都是一个人。室友都做不成朋友。虽然平时觉得一个人挺好的，但是有些情绪真的好想跟人分享啊。我也不是想一个人，而是不喜欢她们', '2018-07-03 21:23:04', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014140889241468930, NULL, 1012870289281667073, '星期二', 'Leon', '30℃', '阴', 1, 1, 0, 4, '爱自拍', 0, 3, '[\"http://img.shaiquan.net/1530625004210/0/1139X1330\"]', 1, '263天的坚持，我的白斩鸡形象一去不复返了，自律的人生是很美的。\n要一直坚持下去！💪💪', '2018-07-03 21:36:44', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014141639224967169, NULL, 1012870289281667073, '星期二', '反正我不要脸', '30℃', '阴', 1, 0, 0, 6, '表情包', 1, 2, '[\"http://img.shaiquan.net/1530625182762/0/385X374\",\"http://img.shaiquan.net/1530625183672/1/495X348\"]', 1, '求表情包，以包换包，来互相伤害吧😂😜', '2018-07-03 21:39:43', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014142974938824705, NULL, 1012956668326014977, '星期二', '小仙仙', '31℃', '阴', 1, 0, 0, 7, '游戏', 1, 1, '[\"http://img.shaiquan.net/1530625501/0/828X620\"]', 2, '有人玩吃鸡吗？萌新求带，谁教我用98K。', '2018-07-03 21:45:02', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014143799497048065, NULL, 1012870289281667073, '星期二', 'Cindy', '30℃', '阴', 1, 0, 0, 8, '秘密', 0, 0, NULL, 1, '我喜欢我闺蜜的男友了\n我知道这句话说出来都带着要接受批判的意味\n但是我觉得我没有错——\n我在和她成为闺蜜之前喜欢的他\n她和我说喜欢他 我什么也没说 撮合了他们两个\n五年过去了\n他们两个分手两年了\n我才又和他见面聊天\n去年他请我出去吃饭\n我们聊的事都告诉她了就怕她多想\n后来他每天从早到晚都和我聊天\n也说了我对于他是不一样的\n因为我们五年前产生了误会 \n居然去年他才知道真相\n我以为我们有希望 但是又觉得他再怎么说也是我最好朋友的前男友 怎么可以这么想\n因为纠结所以我一再的问她是不是对他真的没感觉了\n她说自己很绝情 绝不会回头\n十一月份他们又复合了\n还是她托我转告他 让他表白\n\n之后我再也没有和他私下说过话\n\n我比你更敏感\n\n我能看出来你还喜欢他\n但是我藏了这么久 我做不到控制自己不梦到他\n我知道我们谁都没错\n所以才是症结\n\n我不能失落 不能伤心 因为没有身份 \n不能暴露\n因为他们重新在一起 所以每天打游戏她都会拖着他来一起\n后来我们总是出去玩 因为我和他性格相似 所以话多一些 她个性安静 一般不怎么说话\n假期结束回到学校后她慢慢的和我联系淡了\n每天都是我找她 却很少回\n就是这样没有什么大吵 只是拌了两句嘴 到现在三个多月了 再也没了联系\n我每天每天去微博看她的点赞 猜她活着什么这样的生活\n一开始还会陷在里面想找出原因 我到底做错了什么\n现在只剩下摇摇头', '2018-07-03 21:48:18', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014145132362973185, NULL, 1012870289281667073, '星期二', '心若倦了', '30℃', '阴', 1, 0, 0, 9, '心愿', 3, 3, NULL, 1, '#2018年心愿单#\n1.把现在的项目做起来，能养活自己。\n2.带上老婆和女儿去日本北海道旅游。\n3.给老婆买个mini Cooper\n4.去丽江找大学室友聚聚，一起打鱼野炊', '2018-07-03 21:53:36', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014145356917620738, NULL, 1012956668326014977, '星期二', 'Cindy', '31℃', '阴', 1, 1, 0, 8, '秘密', 2, 6, NULL, 2, '我喜欢我闺蜜的男友了\n我知道这句话说出来都带着要接受批判的意味\n但是我觉得我没有错——\n我在和她成为闺蜜之前喜欢的他\n她和我说喜欢他 我什么也没说 撮合了他们两个\n五年过去了\n他们两个分手两年了\n我才又和他见面聊天\n去年他请我出去吃饭\n我们聊的事都告诉她了就怕她多想\n后来他每天从早到晚都和我聊天\n也说了我对于他是不一样的\n因为我们五年前产生了误会 \n居然去年他才知道真相\n我以为我们有希望 但是又觉得他再怎么说也是我最好朋友的前男友 怎么可以这么想\n因为纠结所以我一再的问她是不是对他真的没感觉了\n她说自己很绝情 绝不会回头\n十一月份他们又复合了\n还是她托我转告他 让他表白\n\n之后我再也没有和他私下说过话\n\n我比你更敏感\n\n我能看出来你还喜欢他\n但是我藏了这么久 我做不到控制自己不梦到他\n我知道我们谁都没错\n所以才是症结\n\n我不能失落 不能伤心 因为没有身份 \n不能暴露\n因为他们重新在一起 所以每天打游戏她都会拖着他来一起\n后来我们总是出去玩 因为我和他性格相似 所以话多一些 她个性安静 一般不怎么说话\n假期结束回到学校后她慢慢的和我联系淡了\n每天都是我找她 却很少回\n就是这样没有什么大吵 只是拌了两句嘴 到现在三个多月了 再也没了联系\n我每天每天去微博看她的点赞 猜她活着什么这样的生活\n一开始还会陷在里面想找出原因 我到底做错了什么\n现在只剩下摇摇头', '2018-07-03 21:54:30', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014146437735235586, NULL, 1012956668326014977, '星期二', '你不知道的事', '31℃', '阴', 1, 0, 0, 10, '恋爱', 1, 3, '[\"http://img.shaiquan.net/1530626326/0/750X1334\"]', 2, '喜欢前桌的男孩子,脾气很好,也被我惹火过,一脸憋屈却不发火只是不理人,唇红齿白,手好看,比较矮,比我高qaq因为认识不长不短,很熟,更不敢轻易表白啥的,什么大不了不做朋友都是狗屁。。能感觉到他喜欢我,可我们也暂时不会在一起。。然后就是，青春期！窝就单纯发发情,啾咪*٩(๑´∀`๑)', '2018-07-03 21:58:47', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014147926767681537, NULL, 1012870289281667073, '星期二', '狙魔人', '30℃', '阴', 1, 0, 0, 12, '电影', 1, 3, '[\"http://img.shaiquan.net/1530626680772/0/1080X1511\"]', 1, '1.没有手抓铁丝网挡飞弹侮辱观众的智商，战争细节很真实，很残酷\n2.没有单手扯五星红旗给你强制灌输脑残爱国主义\n3.狙击手对决紧张刺激，情节紧凑场面燃爆\n4.我并不是针对谁，但是和它比起来，战狼2真的是一坨屎💩', '2018-07-03 22:04:42', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014161950930616321, NULL, 1012939887452581890, '星期二', '小吃货', '32℃', '阴', 1, 0, 0, 2, '美食', 1, 2, '[\"http://img.shaiquan.net/1530630024/0/800X450\"]', 2, '今天自己动手做大餐，吃喝直是爽歪歪', '2018-07-03 23:00:26', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014162426547912705, NULL, 1012939887452581890, '星期二', '喜欢足球的天才', '32℃', '阴', 1, 0, 0, 3, '开心', 0, 1, '[\"http://img.shaiquan.net/1530630137/0/750X1334\"]', 2, '昨天赌球居然中了，大吃大喝起来', '2018-07-03 23:02:19', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014162834536251394, NULL, 1012939887452581890, '星期二', '善感的心灵', '32℃', '阴', 1, 0, 0, -1, '此刻', 3, 4, NULL, 2, '晚上一点睡意都没有，想想明天就要离开读了4年的大学，真有点舍不得舍友，同学', '2018-07-03 23:03:57', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014163478059925506, NULL, 1012939887452581890, '星期二', '孤独的心', '32℃', '阴', 1, 0, 0, 1, '丧', 7, 3, '[\"http://img.shaiquan.net/1530630389/0/690X388\"]', 2, '打开微博，微信，看了一下联系人列表，但却找不到一个可以聊天的人，还是喜欢小魔瓶，有魔友吗？', '2018-07-03 23:06:30', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014171250444976129, NULL, 1012939887452581890, '星期二', '孤独的心', '32℃', '阴', 1, 0, 0, 5, '失眠', 0, 4, NULL, 2, '真的，基本每天都失眠（不知道算不算的上啦）每天一两点才睡，想睡睡不着，明天还要考试，啊啊啊好烦啊(´இ皿இ｀)', '2018-07-03 23:37:23', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014285859332014081, NULL, 1012939887452581890, '星期三', '世界杯只看球', '32℃', '阴', 1, 0, 0, -1, '此刻', 0, 4, NULL, 2, '英格兰🏴󠁧󠁢󠁥󠁮󠁧󠁿终于赢了，这届世界杯就看你们的了，加油', '2018-07-04 07:12:48', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014286231685545985, NULL, 1012939887452581890, '星期三', '无精打采', '32℃', '阴', 1, 0, 0, 1, '丧', 5, 2, NULL, 2, '早上起的太早，困的一笔，单身🐶的人生难道就这样吗？', '2018-07-04 07:14:17', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014286743902339073, NULL, 1012939887452581890, '星期三', '爱吃醋的猫', '32℃', '阴', 1, 0, 1, 5, '失眠', 0, 1, NULL, 2, '昨晚吃烧烤后肚子一直难受😣，半夜3点都还睡不着，看来要控制控制自己了', '2018-07-04 07:16:19', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014287421844471809, NULL, 1012939887452581890, '星期三', '不再是单身🐶', '32℃', '阴', 1, 0, 0, 3, '开心', 5, 4, NULL, 2, '昨晚终于把女神追到手了，希望能好好的过一辈子，人生精彩', '2018-07-04 07:19:01', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014288034607120386, NULL, 1012939887452581890, '星期三', '不再是单身🐶', '32℃', '阴', 1, 1, 0, 8, '秘密', 0, 4, '[\"http://img.shaiquan.net/1530660085/0/590X540\"]', 2, '昨晚居然梦见了一个初中时有那么一点点好感的男生，对我巨温柔，我脾气不好，他还是对我很有耐心。\n然而事实是他对我玩得好的一同学有意思，不过要我是男生，我也觉得我那玩得好的同学有意思。', '2018-07-04 07:21:27', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014324279777312770, NULL, 1012939887452581890, '星期三', '别和我谈理想', '32℃', '阴', 1, 0, 0, -1, '此刻', 0, 2, '[\"http://img.shaiquan.net/1530668727/0/590X540\"]', 2, '今天上班，感觉事不多，时间一点一滴过的直慢', '2018-07-04 09:45:28', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014331018996236289, NULL, 1012939887452581890, '星期三', '吐槽专用', '32℃', '阴', 1, 0, 0, 14, '吐槽', 4, 2, NULL, 2, '我就觉得很搞笑，直男和你聊过一次天，就自以为很熟了。不记得收敛、拿捏尺度，就算是冒犯了你，还会觉得是你开不起玩笑。我拜托你哦，您哪位啊？您觉得您的玩笑好笑吗？值得笑吗？？', '2018-07-04 10:12:15', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014331085241073666, NULL, 1012870289281667073, '星期三', '我只想好好睡个午觉', '28℃', '阴', 1, 0, 0, 14, '吐槽', 0, 1, NULL, 1, '中午办公室午休时，旁边的一个傻叉一直在打呼噜，还有人走来走去，弄出很大的动静，真是一点公德心都没有。', '2018-07-04 10:12:31', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014339140871667714, NULL, 1012870289281667073, '星期三', '贾斯汀', '30℃', '阴', 1, 0, 0, 2, '美食', 1, 3, '[\"http://img.shaiquan.net/1530672270711/0/1488X1984\"]', 1, '感谢团队带给我的惊喜和温暖，自己的今天生日居然给忘了。。。\n生日蛋糕🍰太精致了，很好吃😋！', '2018-07-04 10:44:31', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014342246221103105, NULL, 1012786172036837378, '星期三', '莘莘学子', '30℃', '阴', 1, 0, 0, 6, '表情包', 1, 1, '[\"http://img.shaiquan.net/1530672995410/0/440X408\",\"http://img.shaiquan.net/1530672995857/1/440X440\",\"http://img.shaiquan.net/1530672995954/2/440X440\"]', 2, '从今天起，做一个有梦想，有气质的人，因为我考过了。', '2018-07-04 10:56:52', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014346470598262786, NULL, 1012939887452581890, '星期三', '吐槽专用', '32℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, NULL, 2, '今天上班淋湿了，一点上班的欲望都没有', '2018-07-04 11:13:39', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014384352230785026, NULL, 1012939887452581890, '星期三', '没睡好的狗', '30℃', '阴', 1, 0, 0, 1, '丧', 1, 0, '[\"http://img.shaiquan.net/1530683049/0/750X1334\"]', 2, '午休被身旁的人打呼吵的头痛，下午上班又要没精力了', '2018-07-04 13:44:11', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014385067758075905, NULL, 1013358916616994817, '星期三', 'fully ', '30℃', '阴', 1, 0, 0, -1, '此刻', 1, 0, NULL, 1, '有时候很迷茫\n在家里工作\n很自由 但是又觉得什么都没学到\n感觉自己很没用\n.....\n只想每天开心啊 \n太难了', '2018-07-04 13:47:01', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014419613765484545, NULL, 1012956668326014977, '星期三', '你不知道的事', '28℃', '阴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 2, '今天在路上看到一个傻逼，开车很猛，还狂按喇叭📣。', '2018-07-04 16:04:18', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014450944784351233, NULL, 1012939887452581890, '星期三', 'wonder ', '32℃', '阴', 1, 0, 0, 2, '美食', 0, 0, '[\"http://img.shaiquan.net/1530698926/0/828X711\"]', 2, '今天的下午茶，闺蜜们，明天再来和我讨论减肥', '2018-07-04 18:08:47', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014458308686135297, NULL, 1012939887452581890, '星期三', 'wonder ', '32℃', '阴', 1, 0, 0, 2, '美食', 4, 1, '[\"http://img.shaiquan.net/1530700682/0/828X711\"]', 2, '今天的下午茶，闺蜜们，明天再来和我讨论减肥', '2018-07-04 18:38:03', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014496087767924738, NULL, 1012870289281667073, '星期三', '六六', '31℃', '晴', 1, 0, 0, 3, '开心', 4, 4, '[\"http://img.shaiquan.net/1530709688840/0/1488X1984\"]', 1, '感谢家人为我庆祝生日，很开心。\n从小到大几乎不过生日，很认真地许了一个愿，据说生日许的愿望一般都会成真，希望能实现！', '2018-07-04 21:08:10', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1014666394080256001, NULL, 1012939887452581890, '星期四', '不喝酒的喵', '32℃', '晴', 1, 0, 0, -1, '此刻', 3, 2, '[\"http://img.shaiquan.net/1530750293/0/720X534\"]', 2, '今天晚上部门要去撸串了，告诫自己一定不要喝酒，以免过敏', '2018-07-05 08:24:55', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015469346613309442, NULL, 1012870289281667073, '星期六', '六六', '29℃', '小雨', 1, 0, 0, -1, '此刻', 0, 0, NULL, 1, '今天下很大的雨，带了小鱼儿🐠在外面玩，宝贝很乖，一声都没哭', '2018-07-07 13:35:34', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015471281647071234, NULL, 1012956668326014977, '星期六', '你不知道的事', '29℃', '小雨', 1, 1, 0, -1, '此刻', 0, 0, NULL, 2, '外面下着雨，犹如我心血在滴，爱你那么久，其实算算不容易', '2018-07-07 13:43:15', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015487863538528258, NULL, 1012939887452581890, '星期六', '月光小美女', NULL, NULL, 1, 1, 0, -1, '此刻', 1, 0, NULL, 2, '我知道生活很艰难 黑暗 辛酸\n但我相信善良 光明 努力就有回报\n加油！\n我是鹿小葵本葵！', '2018-07-07 14:49:08', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015492226227068930, NULL, 1012939887452581890, '星期六', '测试一', NULL, NULL, 1, 1, 1, -1, '此刻', 0, 0, NULL, 2, '测试一', '2018-07-07 15:06:28', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015492279096270849, NULL, 1012939887452581890, '星期六', NULL, NULL, NULL, 0, 1, 1, -1, '此刻', 0, 0, NULL, 2, '测试二', '2018-07-07 15:06:41', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015850582213066753, NULL, 1012784423909650434, '星期日', NULL, '30℃', '晴', 0, 1, 1, -1, '此刻', 0, 0, NULL, 1, '快咯抹', '2018-07-08 14:50:27', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015853564027666434, NULL, 1012939887452581890, '星期日', NULL, '30℃', '晴', 0, 1, 1, -1, '此刻', 0, 0, NULL, 2, '丝。', '2018-07-08 15:02:18', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015853930697916418, NULL, 1012939887452581890, '星期日', '小情情', '30℃', '晴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531033424/0/828X621\"]', 2, '今天上午打网球🎾了，全身出完汗的感觉真爽', '2018-07-08 15:03:45', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015854591716032513, NULL, 1012939887452581890, '星期日', '小情情', '30℃', '晴', 1, 0, 0, -1, '此刻', 1, 0, '[\"http://img.shaiquan.net/1531033582/0/828X621\"]', 2, '今天上午打完网球🎾后好爽，真是舒服', '2018-07-08 15:06:23', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015856791326490626, NULL, 1012878480845500418, '星期日', '小星星', '30℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 2, '天气热的一比，还是躺在家里吹着空调舒服。回去看部电影补偿下。', '2018-07-08 15:15:07', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015864028178608130, NULL, 1012878480845500418, '星期日', '赤壁怀古', '30℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 2, '大江东去，浪淘尽千古风流人物。\n故垒西边，人道是，三国周郎赤壁。', '2018-07-08 15:43:53', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015869272954433538, NULL, 1012939887452581890, '星期日', '爱喝酒的猫', '30℃', '晴', 1, 1, 0, -1, '此刻', 2, 1, '[\"http://img.shaiquan.net/1531037082/0/828X1472\"]', 2, '下大雨后，晚上又很好睡觉了，有一起的吗？', '2018-07-08 16:04:43', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015895089759576066, NULL, 1012870289281667073, '星期日', '黄渤', '30℃', '晴', 1, 0, 0, -1, '此刻', 0, 1, '[\"http://img.shaiquan.net/1531043237765/0/720X1280\"]', 1, '我不是药神，这部电影还不错哦，推荐大家去看。', '2018-07-08 17:47:18', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1015904109199319041, NULL, 1012939887452581890, '星期日', '电影王子', '30℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531045387/0/828X828\"]', 2, '今天带我妈去看了动物世界！！简直超过预期值，很喜欢这样的题材，带父母去看不需要太太太深刻的意义，这样的商业片最适合！褒贬不一的评价但是对我来说超级期待第二部！！李易峰很帅！不是那种只能穿白衬衫的帅！', '2018-07-08 18:23:09', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016108777619808257, NULL, 1012939847141126145, '星期一', '电影王子', '30℃', '晴', 1, 0, 0, 1, '丧', 0, 0, '[\"http://img.shaiquan.net/1531094184/0/690X388\"]', 1, '一大早被外面的车声吵醒，上班路上夹杂着严热的太阳，瞬间感觉心情不好了', '2018-07-09 07:56:26', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016109813944246273, NULL, 1012939847141126145, '星期一', '上班族👨‍💼', '30℃', '晴', 1, 0, 0, -1, '此刻', 1, 1, '[\"http://img.shaiquan.net/1531094431/0/828X794\"]', 1, '一到周一就不想起来不想上班，好羡慕退休的人。', '2018-07-09 08:00:33', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016137802941685761, NULL, 1012939847141126145, '星期一', '你型我秀', '28℃', '晴', 1, 0, 0, 4, '爱自拍', 0, 3, '[\"http://img.shaiquan.net/1531101104/0/828X794\"]', 1, '每天的段炼终于有腹肌了，给你秀秀，记得鼓掌哦', '2018-07-09 09:51:46', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016139404649914369, NULL, 1012956668326014977, '星期一', '爱电影🎬', '28℃', '晴', 1, 0, 0, 12, '电影', 1, 1, '[\"http://img.shaiquan.net/1531101485/0/828X1242\"]', 2, '昨天看了头号玩家，故事本身还不错，里面也有很多经典电影梗，但是豆瓣很多人打5星，我觉得还没到5星的水准，看别人总结了100多个彩蛋，80%我都不知道，尴尬😳', '2018-07-09 09:58:08', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016145348003848193, NULL, 1012939847141126145, '星期一', '你型我秀', '28℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '扎堆', '2018-07-09 10:21:45', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016150485673926657, NULL, 1012870983535448066, '星期一', '周冬雨', '28℃', '晴', 1, 0, 0, 12, '电影', 0, 4, '[\"http://img.shaiquan.net/1531104127/0/828X1380\"]', 2, '给李易峰在《动物世界》里的演技疯狂打call，电影本身情节紧凑，特效也是好莱坞级别的。李易峰在里面的表演也给电影增色不少，主角郑开司在经历各种尔虞我诈，人性的自私和残酷后，还能保持守住自己心中的道，是一个很正面的角色。', '2018-07-09 10:42:10', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016154994450063362, NULL, 1012870289281667073, '星期一', '北方的狼', '29℃', '晴', 1, 0, 0, 8, '秘密', 2, 3, NULL, 1, '喜欢上自己的大学英语老师了，她经常穿碎花裙子，说话特别温柔，讲课也很有趣。好几天晚上梦到她了。\n每周上两节课，是我最期待的课，我要向她表白吗？求大神支招，在线等，挺急的。', '2018-07-09 11:00:05', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016261869233463298, NULL, 1012784423909650434, '星期一', '长肥', '31℃', '晴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531130684/0/828X620\"]', 1, '一搜被下班', '2018-07-09 18:04:46', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016262357131681793, NULL, 1012784423909650434, '星期一', '长肥', '31℃', '晴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531130800/0/828X1472\"]', 1, '我是小和尚一禅大师', '2018-07-09 18:06:42', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016262954337656833, NULL, 1012784423909650434, '星期一', '长肥', '31℃', '晴', 1, 0, 0, -1, '此刻', 0, 1, '[\"http://img.shaiquan.net/1531130942/2/828X1472\",\"http://img.shaiquan.net/1531130942/1/640X462\",\"http://img.shaiquan.net/1531130941/0/828X1472\"]', 1, '一禅小和尚来化斋', '2018-07-09 18:09:04', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016263366348333057, NULL, 1012784423909650434, '星期一', '长肥', '31℃', '晴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531131031/0/828X1472\"]', 1, '在真转在真转在真', '2018-07-09 18:10:42', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016263951642484737, NULL, 1012784423909650434, '星期一', '长肥', '31℃', '晴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531131180/1/640X462\",\"http://img.shaiquan.net/1531131181/2/828X1472\",\"http://img.shaiquan.net/1531131180/0/828X1472\"]', 1, '国内旅游者空军建军节空军建军节', '2018-07-09 18:13:02', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1016621876772823042, NULL, 1012786172036837378, '星期二', '紫星', '33℃', '晴', 1, 0, 0, 9, '心愿', 3, 4, '[\"http://img.shaiquan.net/1531216516813/0/780X1040\"]', 2, '今天心情好，老板说这个项目做完，请我们出去旅游，', '2018-07-10 17:55:18', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017014128552665090, NULL, 1012878480845500418, '星期三', '远方', '32℃', '阴', 1, 0, 0, -1, '此刻', 1, 1, '[\"http://img.shaiquan.net/1531310024286/0/1984X1488\"]', 2, '马上就要离开这个呆了将近7年的地方了，中午吃饭的时候看着在园区跑步的同事，心里想我马上我就不属于这个集体了，心里多少有些失落，我会想念这里的。', '2018-07-11 19:53:58', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017231892953391105, NULL, 1012939847141126145, '星期四', '蓝莓干', '29℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, NULL, 1, '糟糕的一天。\n昨晚整栋宿舍停电，到现在还没有电，手机充电线坏了，充不进电。\n想复习也没心情。\n难受。', '2018-07-12 10:19:17', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017232274282733570, NULL, 1012939847141126145, '星期四', '我不孤独', '29℃', '阴', 1, 0, 0, 3, '开心', 0, 0, '[\"http://img.shaiquan.net/1531362047/0/640X640\"]', 1, '啊啊啊~啊啊啊~啊啊啊~啊啊啊~\n西湖美景~三月天嘞~\n春雨如酒~柳如烟嘞~', '2018-07-12 10:20:48', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017232563962339329, NULL, 1012939847141126145, '星期四', '我不孤独', '29℃', '阴', 1, 0, 0, 3, '开心', 1, 2, '[\"http://img.shaiquan.net/1531362116/0/640X640\"]', 1, '啊啊啊~啊啊啊~啊啊啊~啊啊啊~\n西湖美景~三月天嘞~\n春雨如酒~柳如烟嘞~', '2018-07-12 10:21:57', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017234175611068418, NULL, 1012939887452581890, '星期四', '一辈子开心', '29℃', '阴', 1, 0, 0, 14, '吐槽', 3, 2, '[\"http://img.shaiquan.net/1531362500/0/828X485\"]', 2, '对啊，优秀的人都遇到了优秀的人\n可爱的人都遇到了可爱的人\n温暖的人都遇到了温暖的人\n像我这么糟糕的人注定遇不到很好的人了叭', '2018-07-12 10:28:21', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017234817251500033, NULL, 1012939887452581890, '星期四', '一辈子开心', '29℃', '阴', 1, 0, 0, 5, '失眠', 0, 1, NULL, 2, '已经连续一个月失眠了 连续一个月每天晚上很难入睡，因为男朋友 父母不满意，男朋友现在和以后要创业，而我想要安稳的生活，男朋友老家离我所在省份很远，目前他在老家创业 ，说创业成功回来我的城市。哎 好烦 真的不知道要不要分', '2018-07-12 10:30:54', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017235590731489282, NULL, 1012939847141126145, '星期四', '一辈子开心', '29℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, NULL, 1, '以后不能混日子了 该努力了  希望有一个矮矮的女生一直陪着我 然后让我把他给娶了 😄😄', '2018-07-12 10:33:59', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017236502103416834, NULL, 1012939847141126145, '星期四', '看风景的娃', '29℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531363055/0/828X621\"]', 1, '每天做相同的事情、坐相同的地铁线路回家、每天都是两点一线,对，重要的是每天可以看风景', '2018-07-12 10:37:36', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017236867796393985, NULL, 1012939847141126145, '星期四', '风景如人', '29℃', '阴', 1, 0, 0, 1, '丧', 0, 0, NULL, 1, '人生因为有美，所以最后一定是悲剧。我是那么的爱你，所以才会让我过的如此的凄凉。有幸的是我在你身上找到了世界上最美的感情，不幸的是我在你身上耗尽了一生。本来我应该像人们掸掉身上衣服的刺一样把你从我的生活中清扫出去。但这并不是我想要做的事，我只想坦率的说出自己内心的真实想法。即便这样做会让我丧失理智，这种行动的惩罚，也不过是让我丢掉了对其他人的爱意罢了。不论在哪个地方，有你的地方，便是我的世界。看不到你的明天，只是在无数的轮回中的一小段、上帝的眨眼的一瞬、雨滴打落地面的那一霎那而已，我没有必要对此感到失望，因为...我们的生命都卑微的如尘埃一般，对你的感情，也不过是那一霎那的光芒，光芒过后，我们都会化为尘土，爱你、会让我热爱生活，爱自己、却是终生浪漫的开始。即使你并不会看到我写给你的书信，但我依然不会停止，起码在我这短暂的生命中。', '2018-07-12 10:39:03', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017264050807988226, NULL, 1012939847141126145, '星期四', '风景如人', '31℃', '阴', 1, 0, 0, 14, '吐槽', 0, 6, NULL, 1, '有时候，莫名的心情不好，不想和任何人说话，只想一个人静静的发呆。有时候，夜深人静，突然觉得不是睡不着，而是固执地不想睡。有时候，听到一首歌，就会突然想起一个人。有时候，别人突然对你说，我觉得你变了，然后自己开始百感交集。——丢了的自己，只能慢慢捡回来。', '2018-07-12 12:27:04', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017265821617971202, NULL, 1012939887452581890, '星期四', '不抛弃不放弃', '31℃', '阴', 1, 0, 0, -1, '此刻', 1, 0, '[\"http://img.shaiquan.net/1531370045/0/300X386\"]', 2, '人生不过是一场旅行，你路过我，我路过你，然后各自向前，各自修行。在岁月中跋涉，每个人都有自己的故事，看淡心境才会秀丽，看开心情才会明媚。好好扮演自己的角色，做自己该做的事。生活不可能像你想象得那么好，但也不会像你想象得那么糟。人的脆弱和坚强都超乎自己的想象。有时，可能脆弱得一句话就泪流满面，有时，也发现自己咬着牙走了很长的路。', '2018-07-12 12:34:06', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017331913866567682, NULL, 1017331210137853953, '星期四', '嗯嗯', '33℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '嗯嗯', '2018-07-12 16:56:44', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017376732647219201, NULL, 1017376287602204674, '星期四', '安安', '28℃', '多云', 1, 0, 0, -1, '此刻', 2, 2, '[\"http://img.shaiquan.net/1531396487950/0/960X720\"]', 1, '这个app好小清新啊，准备推荐给朋友了', '2018-07-12 19:54:50', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017390138930454530, NULL, 1017389002026606593, '星期四', '了解一下', '27℃', '小雨', 1, 1, 0, -1, '此刻', 0, 1, NULL, 2, '用这个app的朋友麻烦去了解一下一个叫“一罐”的app，这真的是别人火了马上又抄袭过来的，界面还超级丑，不管怎样，抄袭真的很low', '2018-07-12 20:48:06', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017392884001759233, NULL, 1017389002026606593, '星期四', '了解一下', '27℃', '小雨', 1, 1, 0, 8, '秘密', 0, 0, NULL, 2, '用这个app的朋友麻烦去了解一下一个叫“一罐”的app，这真的是别人火了马上又抄袭过来的，界面还超级丑，不管怎样，抄袭真的很low', '2018-07-12 20:59:00', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017392911109545986, NULL, 1012939887452581890, '星期四', '小可爱', '32℃', '阴', 1, 0, 0, 8, '秘密', 5, 2, NULL, 2, '我出生的时候因为是个女孩子差点被送出去\n后来我奶奶觉得我长的还挺好看的就把我留下来了\n说实在的\n我讨厌我这张脸', '2018-07-12 20:59:07', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017393176676098050, NULL, 1017389002026606593, '星期四', '了解一下', '27℃', '小雨', 1, 1, 0, 3, '开心', 0, 0, NULL, 2, '用这个app的朋友麻烦去了解一下一个叫“一罐”的app，这真的是别人火了马上又抄袭过来的，界面还超级丑，不管怎样，抄袭真的很low', '2018-07-12 21:00:10', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017393478762455041, NULL, 1017389002026606593, '星期四', '了解一下', '27℃', '小雨', 1, 1, 0, 5, '失眠', 0, 0, NULL, 2, '用这个app的朋友麻烦去了解一下一个叫“一罐”的app，这真的是别人火了马上又抄袭过来的，界面还超级丑，不管怎样，抄袭真的很low', '2018-07-12 21:01:22', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017394147720388610, NULL, 1017389002026606593, '星期四', '了解一下', '27℃', '小雨', 1, 1, 0, 1, '丧', 0, 0, NULL, 2, '用这个app的朋友麻烦去了解一下一个叫“一罐”的app，这真的是别人火了马上又抄袭过来的，界面还超级丑，不管怎样，抄袭真的很low', '2018-07-12 21:04:02', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017395654146613250, NULL, 1012870289281667073, '星期四', '确认过眼神', NULL, NULL, 1, 0, 0, -1, '此刻', 0, 0, NULL, 1, '一罐情绪，神奇魔瓶。喜欢这个APP，让我遇到了陌生人的温暖的安慰', '2018-07-12 21:10:01', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017396576415342594, NULL, 1017396355904004097, '星期四', 'io', '31℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '纯抄袭呀。。。', '2018-07-12 21:13:41', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017396905542377474, NULL, 1012956668326014977, '星期四', '周冬雨', '31℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, NULL, 2, '今天遇到一个傻逼，真是倒了八辈子霉了，发誓再也不会出现第二次，一罐', '2018-07-12 21:14:59', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017397276906053633, NULL, 1017396355904004097, '星期四', '抵制抄袭', '31℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '这个软件纯抄袭呀！！不信大家下载 一罐这个app。抵制抄袭！！！！', '2018-07-12 21:16:28', NULL, 0, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017397309789396993, NULL, 1012870289281667073, '星期四', '确认过眼神', NULL, NULL, 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '一罐罐啤酒，都被我们喝喝完了，球赛太精彩！', '2018-07-12 21:16:36', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017399029009440770, NULL, 1012901580446285826, '星期四', '呵呵呵', '32℃', '阴', 1, 0, 0, -1, '此刻', 0, 0, '[\"http://img.shaiquan.net/1531401804/0/828X621\"]', 2, '一罐这个哈哈哈哈哈哈哈哈哈哈哈', '2018-07-12 21:23:26', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1017405825862295554, NULL, 1012901580446285826, '星期四', '呵呵呵嘿嘿', '32℃', '阴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 2, '一罐哈哈哈哈哈哈哈哈哈哈哈哈', '2018-07-12 21:50:26', NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `post` VALUES (1186074518315323394, NULL, 1186066362742853633, '星期一', '一壶好酒', '22℃', '晴', 1, 0, 0, -1, '此刻', 1, 1, NULL, 1, '今天天气不错，整个人都充满了活力，早上起来又一个美好的一天开始了。', '2019-10-21 08:19:36', NULL, 0, NULL, 0, 26, '萌新报到');
INSERT INTO `post` VALUES (1186082395687952386, NULL, 1186081770891845633, '星期一', '地铁上的一天', '22℃', '晴', 1, 1, 0, -1, '此刻', 0, 0, NULL, 1, '地铁上发个帖子，看谁也在玩。', '2019-10-21 08:50:54', NULL, 0, NULL, 0, 26, '萌新报到');
COMMIT;

-- ----------------------------
-- Table structure for post_reply
-- ----------------------------
DROP TABLE IF EXISTS `post_reply`;
CREATE TABLE `post_reply` (
  `id` bigint(20) NOT NULL,
  `post_id` bigint(20) NOT NULL COMMENT '魔瓶Id',
  `from_uid` bigint(20) NOT NULL COMMENT '用户id',
  `from_nick_name` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `to_nick_name` varchar(255) DEFAULT NULL,
  `to_uid` bigint(20) DEFAULT NULL COMMENT '目标用户id',
  `to_sex` tinyint(1) DEFAULT NULL COMMENT '目标性别',
  `from_sex` tinyint(1) DEFAULT NULL COMMENT '回复人性别',
  `content` text NOT NULL COMMENT '回复内容',
  `create_time` datetime NOT NULL,
  `shield_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否被屏蔽 0否 1是',
  `deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 0：否 1：是',
  `comment_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '评论类型 1：评论 2：回复',
  PRIMARY KEY (`id`),
  KEY `idx_post_id` (`post_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='帖子回复表';

-- ----------------------------
-- Records of post_reply
-- ----------------------------
BEGIN;
INSERT INTO `post_reply` VALUES (1012728369876271106, 1012728209137958913, 1012728219816656897, '一禅', NULL, 1012727922658607106, 2, 1, '哈哈', '2018-06-30 00:03:54', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012728652622692353, 1012728509571760130, 1012727922658607106, '紫星好评', '一禅', 1012728219816656897, 1, 2, '这个不错的', '2018-06-30 00:05:01', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012728879278686210, 1012728209137958913, 1012728219816656897, '一禅', '紫星好评', 1012727922658607106, 2, 1, '图腾', '2018-06-30 00:05:55', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012730348799180802, 1012728209137958913, 1012728219816656897, '一禅', '紫星好评', 1012727922658607106, 2, 1, '发给你', '2018-06-30 00:11:45', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012730352028794882, 1012728209137958913, 1012728219816656897, '一禅', '紫星好评', 1012727922658607106, 2, 1, '发给你', '2018-06-30 00:11:46', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012730356093075457, 1012728209137958913, 1012728219816656897, '一禅', '紫星好评', 1012727922658607106, 2, 1, '发给你', '2018-06-30 00:11:47', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012730471453212673, 1012728209137958913, 1012728219816656897, '一禅', '紫星好评', 1012727922658607106, 2, 1, '好', '2018-06-30 00:12:15', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012730588516237313, 1012728509571760130, 1012727922658607106, '紫星好评', '一禅', 1012728219816656897, 1, 2, '小和尚恋爱了啊', '2018-06-30 00:12:43', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012807631929012226, 1012794173535744002, 1012786172036837378, '我是学霸', '我是学霸', 1012786172036837378, 2, 2, '这个可以有', '2018-06-30 05:18:51', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012807653827473410, 1012794173535744002, 1012786172036837378, '我是学霸', '我是学霸', 1012786172036837378, 2, 2, '不错了', '2018-06-30 05:18:56', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012875562817875969, 1012784666663383042, 1012870983535448066, '大神', NULL, 1012784423909650434, 1, 2, '你好', '2018-06-30 09:48:47', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012881901187125249, 1012873065063665665, 1012878480845500418, '小西西', '大神', 1012870983535448066, 2, 2, '第一次自定义要评论昵称后，都不能继续跳转到评论界面', '2018-06-30 10:13:58', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012883521761333249, 1012784666663383042, 1012870983535448066, '大神', NULL, 1012784423909650434, 1, 2, '你好', '2018-06-30 10:20:25', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012885469663219713, 1012873065063665665, 1012870289281667073, '我是管理员', '大神', 1012870983535448066, 2, 1, '好的', '2018-06-30 10:28:09', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012885567273062402, 1012883059469340673, 1012870289281667073, '我是管理员', '小西西', 1012878480845500418, 2, 1, '睡眠', '2018-06-30 10:28:32', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012893829162778625, 1012893026779840514, 1012878480845500418, '小西西', '大神', 1012870983535448066, 2, 2, '😂😂😃😃', '2018-06-30 11:01:22', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012893903729115137, 1012883059469340673, 1012878480845500418, '小西西', '我是管理员', 1012870289281667073, 1, 2, '真的。', '2018-06-30 11:01:40', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012893946741702658, 1012883059469340673, 1012878480845500418, '小西西', '小西西', 1012878480845500418, 2, 2, '好', '2018-06-30 11:01:50', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012897025671217153, 1012887262560407553, 1012878480845500418, '小西西', '大神', 1012870983535448066, 2, 2, '帅气', '2018-06-30 11:14:04', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012906920567078914, 1012794173535744002, 1012901580446285826, '😇😊😭😉', '我是学霸', 1012786172036837378, 2, 2, '哈哈', '2018-06-30 11:53:23', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012929117109055490, 1012883059469340673, 1012901580446285826, '😇😊😭😉', '小西西', 1012878480845500418, 2, 2, '经典', '2018-06-30 13:21:35', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012951875612274690, 1012893437091823617, 1012870289281667073, '我是管理员', '大神', 1012870983535448066, 2, 1, '😃', '2018-06-30 14:52:02', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012957802188992514, 1012899079206649857, 1012956668326014977, 's long bog', '我是管理员', 1012870289281667073, 1, 2, '哈哈', '2018-06-30 15:15:35', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012957807515758594, 1012899079206649857, 1012939887452581890, '好', '我是管理员', 1012870289281667073, 1, 2, '好', '2018-06-30 15:15:36', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012960920050036737, 1012956507252158466, 1012956668326014977, 's long bog', '好', 1012939887452581890, 2, 2, 'Me too', '2018-06-30 15:27:58', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012961344257748994, 1012956507252158466, 1012870289281667073, '我是管理员', '好', 1012939887452581890, 2, 1, '看看性别', '2018-06-30 15:29:39', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012963155165278210, 1012963033895366657, 1012939887452581890, '好', 's long ang', 1012962325057990657, 1, 2, '你好', '2018-06-30 15:36:51', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012967565454905346, 1012967387138265090, 1012870983535448066, '大神', '我是管理员', 1012870289281667073, 1, 2, '宁军', '2018-06-30 15:54:22', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1012967726725894146, 1012967387138265090, 1012870983535448066, '大神', '我是管理员', 1012870289281667073, 1, 2, '葛洪', '2018-06-30 15:55:01', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012967747059879938, 1012967387138265090, 1012870289281667073, '我是管理员', '我是管理员', 1012870289281667073, 1, 1, '性别显示？', '2018-06-30 15:55:06', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012967882275852290, 1012967387138265090, 1012878480845500418, '小西西', '我是管理员', 1012870289281667073, 1, 2, '我这个号是女的哦', '2018-06-30 15:55:38', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012968224992432129, 1012967387138265090, 1012878480845500418, '小西西', '大神', 1012870983535448066, 2, 2, '回复呢', '2018-06-30 15:57:00', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012973187801976833, 1012963033895366657, 1012870289281667073, '荣耀qq317751546', 's long ang', 1012962325057990657, 1, 1, '这个是谁发的贴？', '2018-06-30 16:16:43', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012974314131984385, 1012974262361690113, 1012870289281667073, '荣耀qq317751546', '荣耀qq317751546', 1012870289281667073, 1, 1, '自己评论', '2018-06-30 16:21:11', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012974830538887170, 1012974262361690113, 1012956668326014977, '苹果6sp微信159', '荣耀qq317751546', 1012870289281667073, 1, 2, '来来', '2018-06-30 16:23:14', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012975213143298050, 1012974262361690113, 1012939887452581890, '苹果6伍角', '荣耀qq317751546', 1012870289281667073, 1, 2, '来', '2018-06-30 16:24:46', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012975417217159170, 1012974262361690113, 1012870983535448066, '锤子dreamer', '荣耀qq317751546', 1012870289281667073, 1, 2, '来', '2018-06-30 16:25:34', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012981226344976385, 1012974262361690113, 1012878480845500418, '荣耀微信刘林', '荣耀qq317751546', 1012870289281667073, 1, 2, '我来了', '2018-06-30 16:48:39', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012992730364547074, 1012992530384326658, 1012901580446285826, '😇😊😭😉', '😇😊😭😉', 1012901580446285826, 2, 2, '自己的评论', '2018-06-30 17:34:22', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1012993042521427969, 1012992530384326658, 1012784423909650434, '杨大厨', '😇😊😭😉', 1012901580446285826, 2, 1, '不错', '2018-06-30 17:35:36', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012994896428961794, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '杨大厨', 1012784423909650434, 1, 2, '开心吗', '2018-06-30 17:42:59', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012994896433156097, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '杨大厨', 1012784423909650434, 1, 2, '开心吗', '2018-06-30 17:42:59', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012994989408292866, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '杨大厨', 1012784423909650434, 1, 2, '我擦，卡了', '2018-06-30 17:43:21', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012995847814549506, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '杨大厨', 1012784423909650434, 1, 2, '是评论', '2018-06-30 17:46:45', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012996280494755842, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '😇😊😭😉', 1012901580446285826, 2, 2, '黑帝', '2018-06-30 17:48:28', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012996314049187841, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '😇😊😭😉', 1012901580446285826, 2, 2, '自己回复的', '2018-06-30 17:48:36', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1012998748607778817, 1012993251490041858, 1012901580446285826, '😇😊😭😉', '杨大厨', 1012784423909650434, 1, 2, '黑帝', '2018-06-30 17:58:17', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013028253267300354, 1013023863810723842, 1012784423909650434, '杨大厨', '杨大厨', 1012784423909650434, 1, 1, '厚', '2018-06-30 19:55:31', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013213042175807490, 1012993251490041858, 1012784423909650434, '杨大厨', '杨大厨', 1012784423909650434, 1, 1, '图呢', '2018-07-01 08:09:49', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013266406477565953, 1013265904125775873, 1012901580446285826, '名字好难取', '杨大厨', 1012784423909650434, 1, 2, '极好的', '2018-07-01 11:41:52', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013269432747593730, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '好的', '2018-07-01 11:53:53', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013272466781278209, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '私聊', '2018-07-01 12:05:56', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013272723141332994, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '好累', '2018-07-01 12:06:58', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013273991981207553, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '输入', '2018-07-01 12:12:00', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013274056820953090, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '兔兔', '2018-07-01 12:12:16', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013274156129488897, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '取', '2018-07-01 12:12:39', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013274654228254721, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '数据库', '2018-07-01 12:14:38', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013274682653052929, 1013265904125775873, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '佟丽娅', '2018-07-01 12:14:45', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013274776848732162, 1013274724935831554, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '他咯呀', '2018-07-01 12:15:07', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013274816258412546, 1013274724935831554, 1012901580446285826, '名字好难取啊', '杨大厨', 1012784423909650434, 1, 2, '兔兔', '2018-07-01 12:15:17', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013275159021129729, 1013267127444869122, 1012784423909650434, '退咯弄', '名字好难取啊', 1012901580446285826, 2, 1, '普通', '2018-07-01 12:16:38', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013277273353007106, 1013267127444869122, 1012784423909650434, '退咯弄', '名字好难取啊', 1012901580446285826, 2, 1, '来来来', '2018-07-01 12:25:02', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013277278054821889, 1013267127444869122, 1012784423909650434, '退咯弄', '名字好难取啊', 1012901580446285826, 2, 1, '来来来', '2018-07-01 12:25:04', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013279700462514177, 1013274724935831554, 1012784423909650434, '退咯弄', '退咯弄', 1012784423909650434, 1, 1, '来来来', '2018-07-01 12:34:41', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013283030165270530, 1013281573915504642, 1012784423909650434, '微信10', '紫星二次元', 1012787364716539906, 1, 1, '套路狗', '2018-07-01 12:47:55', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013283050159517698, 1013281573915504642, 1012784423909650434, '微信10', '紫星二次元', 1012787364716539906, 1, 1, '哈哈', '2018-07-01 12:48:00', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013283195290824705, 1013281573915504642, 1012901580446285826, '微信20', '紫星二次元', 1012787364716539906, 1, 2, '普通', '2018-07-01 12:48:34', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013283333337952257, 1013281573915504642, 1012787364716539906, '紫星二次元', '紫星二次元', 1012787364716539906, 1, 1, '你们这都说的是啥啊？', '2018-07-01 12:49:07', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013283365013336066, 1013281573915504642, 1012784423909650434, '微信10', '微信20', 1012901580446285826, 2, 1, '退咯弄', '2018-07-01 12:49:15', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013286243878744065, 1013281573915504642, 1012901580446285826, '微信20', '紫星二次元', 1012787364716539906, 1, 2, '兔兔', '2018-07-01 13:00:41', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013318764930707457, 1013318328676954113, 1012870983535448066, '苹果6spDr', '苹果6伍角', 1012939887452581890, 2, 2, '来吧', '2018-07-01 15:09:55', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013318821738360833, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6spDr', 1012870983535448066, 2, 2, '嗯', '2018-07-01 15:10:08', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013320819162394625, 1013318328676954113, 1012956668326014977, '苹果6sp微信159', '苹果6伍角', 1012939887452581890, 2, 2, '这是我的评论', '2018-07-01 15:18:05', 0, 0, 1);
INSERT INTO `post_reply` VALUES (1013322712014041090, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:36', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013322718833979394, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:37', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013322721186983938, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:38', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013322721895821314, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:38', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013322741743267841, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:43', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1013322741743267842, 1013318328676954113, 1012939887452581890, '苹果6伍角', '苹果6伍角', 1012939887452581890, 2, 2, '大家好', '2018-07-01 15:25:43', 0, 1, 1);
INSERT INTO `post_reply` VALUES (1186082514751660033, 1186074518315323394, 1186081770891845633, '吃', NULL, 1186066362742853633, 1, 1, '地铁上', '2019-10-21 08:51:23', 0, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_3', 'DEFAULT', '0 0/10 * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `ENTRY_ID` varchar(95) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) CHARACTER SET utf8 NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 NOT NULL,
  `IS_DURABLE` varchar(1) CHARACTER SET utf8 NOT NULL,
  `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 NOT NULL,
  `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', NULL, 'com.teorange.magic.bottle.admin.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158BAF593307874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B020000787000000000000000017400047465737474000672656E72656E74000FE69C89E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', NULL, 'com.teorange.magic.bottle.admin.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158C377C4607874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000274000574657374327074000FE697A0E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017800);
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_3', 'DEFAULT', NULL, 'com.teorange.magic.bottle.admin.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B787074000CE5AFBCE585A5E5B896E5AD907372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000165239D5EC77874000E3020302F3130202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000374000B657863656C496D706F7274740009687869616F6C69616E740000737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `LOCK_NAME` varchar(40) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('teorange_bottle_command', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('teorange_bottle_command', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'iZwz9c3qewe49ignagx5cuZ1571618037699', 1571632825210, 15000);
INSERT INTO `qrtz_scheduler_state` VALUES ('teorange_bottle_command', 'iZwz9c3qewe49ignagx5cuZ1571618048712', 1571632831846, 15000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `STR_PROP_1` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `STR_PROP_2` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `STR_PROP_3` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `JOB_NAME` varchar(200) CHARACTER SET utf8 NOT NULL,
  `JOB_GROUP` varchar(200) CHARACTER SET utf8 NOT NULL,
  `DESCRIPTION` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 NOT NULL,
  `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', NULL, 1571634000000, 1571632200000, 5, 'WAITING', 'CRON', 1526832307000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158BAF593307874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740004746573747400056D6167696374000FE69C89E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000007800);
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', NULL, 1526833800000, -1, 5, 'PAUSED', 'CRON', 1526832307000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000158C377C4607874000E3020302F3330202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000274000574657374327074000FE697A0E58F82E695B0E6B58BE8AF95737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017800);
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_3', 'DEFAULT', 'TASK_3', 'DEFAULT', NULL, 1533901200000, -1, 5, 'PAUSED', 'CRON', 1533900840000, 0, NULL, 2, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B455973720044636F6D2E74656F72616E67652E6D616769632E626F74746C652E61646D696E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200084C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C000A6D6574686F644E616D6571007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B7870740008746573745461736B7372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000165239D60287874000E3020302F3130202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000374000B657863656C496D706F72747400013570737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0013000000017800);
COMMIT;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) CHARACTER SET utf8 DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` VALUES (1, 'testTask', 'test', 'magic', '0 0/30 * * * ?', 0, '有参数测试', '2016-12-01 23:16:46');
INSERT INTO `schedule_job` VALUES (2, 'testTask', 'test2', NULL, '0 0/30 * * * ?', 1, '无参数测试', '2016-12-03 14:55:56');
INSERT INTO `schedule_job` VALUES (3, 'testTask', 'excelImport', '5', '0 0/10 * * * ?', 1, NULL, '2018-08-10 19:34:01');
COMMIT;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) CHARACTER SET utf8 DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) CHARACTER SET utf8 DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54420 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job_log` VALUES (54377, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 11, '2019-10-20 21:20:00');
INSERT INTO `schedule_job_log` VALUES (54378, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 21:30:00');
INSERT INTO `schedule_job_log` VALUES (54379, 1, 'testTask', 'test', 'magic', 0, NULL, 1012, '2019-10-20 21:30:00');
INSERT INTO `schedule_job_log` VALUES (54380, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 21:40:00');
INSERT INTO `schedule_job_log` VALUES (54381, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 21:50:00');
INSERT INTO `schedule_job_log` VALUES (54382, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 22:00:00');
INSERT INTO `schedule_job_log` VALUES (54383, 1, 'testTask', 'test', 'magic', 0, NULL, 1004, '2019-10-20 22:00:00');
INSERT INTO `schedule_job_log` VALUES (54384, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 2, '2019-10-20 22:10:00');
INSERT INTO `schedule_job_log` VALUES (54385, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 22:20:00');
INSERT INTO `schedule_job_log` VALUES (54386, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 22:30:00');
INSERT INTO `schedule_job_log` VALUES (54387, 1, 'testTask', 'test', 'magic', 0, NULL, 1004, '2019-10-20 22:30:00');
INSERT INTO `schedule_job_log` VALUES (54388, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 18, '2019-10-20 22:40:00');
INSERT INTO `schedule_job_log` VALUES (54389, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 22:50:00');
INSERT INTO `schedule_job_log` VALUES (54390, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 23:00:00');
INSERT INTO `schedule_job_log` VALUES (54391, 1, 'testTask', 'test', 'magic', 0, NULL, 1004, '2019-10-20 23:00:00');
INSERT INTO `schedule_job_log` VALUES (54392, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 2, '2019-10-20 23:10:00');
INSERT INTO `schedule_job_log` VALUES (54393, 3, 'testTask', 'excelImport', '5', 1, 'java.util.concurrent.ExecutionException: cn.teorange.framework.core.exception.RRException: 执行定时任务失败', 1, '2019-10-20 23:20:00');
INSERT INTO `schedule_job_log` VALUES (54394, 1, 'testTask', 'test', 'magic', 0, NULL, 1014, '2019-10-20 23:30:00');
INSERT INTO `schedule_job_log` VALUES (54395, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 00:00:00');
INSERT INTO `schedule_job_log` VALUES (54396, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 00:30:00');
INSERT INTO `schedule_job_log` VALUES (54397, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 01:00:00');
INSERT INTO `schedule_job_log` VALUES (54398, 1, 'testTask', 'test', 'magic', 0, NULL, 1006, '2019-10-21 01:30:00');
INSERT INTO `schedule_job_log` VALUES (54399, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 02:00:00');
INSERT INTO `schedule_job_log` VALUES (54400, 1, 'testTask', 'test', 'magic', 0, NULL, 1006, '2019-10-21 02:30:00');
INSERT INTO `schedule_job_log` VALUES (54401, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 03:00:00');
INSERT INTO `schedule_job_log` VALUES (54402, 1, 'testTask', 'test', 'magic', 0, NULL, 1006, '2019-10-21 03:30:00');
INSERT INTO `schedule_job_log` VALUES (54403, 1, 'testTask', 'test', 'magic', 0, NULL, 1006, '2019-10-21 04:00:00');
INSERT INTO `schedule_job_log` VALUES (54404, 1, 'testTask', 'test', 'magic', 0, NULL, 1006, '2019-10-21 04:30:00');
INSERT INTO `schedule_job_log` VALUES (54405, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 05:00:00');
INSERT INTO `schedule_job_log` VALUES (54406, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 05:30:00');
INSERT INTO `schedule_job_log` VALUES (54407, 1, 'testTask', 'test', 'magic', 0, NULL, 1003, '2019-10-21 06:00:00');
INSERT INTO `schedule_job_log` VALUES (54408, 1, 'testTask', 'test', 'magic', 0, NULL, 1004, '2019-10-21 06:30:00');
INSERT INTO `schedule_job_log` VALUES (54409, 1, 'testTask', 'test', 'magic', 0, NULL, 1008, '2019-10-21 07:00:00');
INSERT INTO `schedule_job_log` VALUES (54410, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 07:30:00');
INSERT INTO `schedule_job_log` VALUES (54411, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 08:00:00');
INSERT INTO `schedule_job_log` VALUES (54412, 1, 'testTask', 'test', 'magic', 0, NULL, 1029, '2019-10-21 09:00:00');
INSERT INTO `schedule_job_log` VALUES (54413, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 09:30:00');
INSERT INTO `schedule_job_log` VALUES (54414, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 10:00:00');
INSERT INTO `schedule_job_log` VALUES (54415, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 10:30:00');
INSERT INTO `schedule_job_log` VALUES (54416, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 11:00:00');
INSERT INTO `schedule_job_log` VALUES (54417, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 11:30:00');
INSERT INTO `schedule_job_log` VALUES (54418, 1, 'testTask', 'test', 'magic', 0, NULL, 1005, '2019-10-21 12:00:00');
INSERT INTO `schedule_job_log` VALUES (54419, 1, 'testTask', 'test', 'magic', 0, NULL, 1007, '2019-10-21 12:30:00');
COMMIT;

-- ----------------------------
-- Table structure for screen_ad
-- ----------------------------
DROP TABLE IF EXISTS `screen_ad`;
CREATE TABLE `screen_ad` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `config_key` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'key',
  `img_url` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '图片地址',
  `link_url` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '广告链接',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `is_show` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开启 0：是 1：否',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='开屏广告';

-- ----------------------------
-- Records of screen_ad
-- ----------------------------
BEGIN;
INSERT INTO `screen_ad` VALUES (1, 'ios', 'http://img.shaiquan.net/20181216/6fc8ea744702467b8a7745d3682a3237.jpg', NULL, '2018-06-09 12:54:42', 0);
INSERT INTO `screen_ad` VALUES (2, 'android', 'http://img.shaiquan.net/20181216/44a40fd554454f5181399adf64814404.png', 'http://element-cn.eleme.io', '2018-06-09 12:55:05', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_captcha
-- ----------------------------
DROP TABLE IF EXISTS `sys_captcha`;
CREATE TABLE `sys_captcha` (
  `uuid` char(36) CHARACTER SET utf8 NOT NULL COMMENT 'uuid',
  `code` varchar(6) CHARACTER SET utf8 NOT NULL COMMENT '验证码',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统验证码';

-- ----------------------------
-- Records of sys_captcha
-- ----------------------------
BEGIN;
INSERT INTO `sys_captcha` VALUES ('476e069a-6cfe-4dfe-89bd-fcc93e115ad5', '3agyw', '2019-10-20 23:30:47');
INSERT INTO `sys_captcha` VALUES ('4c2b16ff-26de-43ec-8659-3018cfbbc8a5', 'ng88w', '2019-10-21 07:19:53');
INSERT INTO `sys_captcha` VALUES ('51c5d391-d451-4608-815a-c51abb017ba2', 'gnpx2', '2019-10-21 00:13:45');
INSERT INTO `sys_captcha` VALUES ('7cc04db1-e599-43a7-8bdb-ae0cb89a8113', '6xn45', '2019-10-20 21:26:15');
INSERT INTO `sys_captcha` VALUES ('cb7feed8-fe08-46e1-87d2-eefb02d794f7', 'df2yc', '2019-10-21 00:13:43');
INSERT INTO `sys_captcha` VALUES ('cf06cd0a-14f0-421b-83fb-3cc08ad5c6f5', '8xend', '2019-10-20 23:31:08');
INSERT INTO `sys_captcha` VALUES ('dbbb76d7-492f-4565-80f5-fef881c72303', 'xx5cx', '2019-10-21 00:13:45');
INSERT INTO `sys_captcha` VALUES ('f82e4372-6997-4f1c-826c-ab68074927ee', 'b5273', '2019-10-20 23:31:50');
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT 'key',
  `value` varchar(2000) CHARACTER SET utf8 DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `param_key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置信息表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://img.shaiquan.net\",\"qiniuAccessKey\":\"xjT02kzY1DW0xCux5Bcyc5LWomgNE1evfa8_UwN7\",\"qiniuSecretKey\":\"-3azGALN-VK6km0brv59qr7P2dDVV7GdEV9yNAOs\",\"qiniuBucketName\":\"magicbottle\"}', 0, '云存储配置信息');
INSERT INTO `sys_config` VALUES (2, 'post_tipoff_shield_count', '5', 1, '魔瓶、评论被不同ip举报自动屏蔽数量');
INSERT INTO `sys_config` VALUES (3, 'user_tipoff_config', '{\"x\":\"1\",\"y\":\"2\",\"z\":\"4\",\"n\":\"3\"}', 1, '用户被禁言配置，X天内触发Y次举报后，自动发送系统警告，然后再触发Z次举报给禁言N天');
INSERT INTO `sys_config` VALUES (4, 'post_min_length', '25', 1, '非图帖子最少文字长度');
INSERT INTO `sys_config` VALUES (5, 'auto_clear_msg_day', '30', 1, '自动删除消息天数');
INSERT INTO `sys_config` VALUES (6, 'admin_user_list', '[\"1012870289281667073\",\"1012878480845500418\",\"1012939887452581890\",\"1012939847141126145\",\"1017376287602204674\",\"1012901580446285826\",\"1062246509585752065\",\"1023585044036292609\"]', 1, '管理员账号');
INSERT INTO `sys_config` VALUES (7, 'gray_people', '[\"1012784423909650434\"]', 1, '灰度名单');
INSERT INTO `sys_config` VALUES (8, 'sheet_lineNumber', '53526', 1, '自动发帖行数');
INSERT INTO `sys_config` VALUES (9, 'post_time_limit', '1800', 1, '发帖时间间隔（单位秒）');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) CHARACTER SET utf8 DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (148, 'admin', '暂停定时任务', 'com.teorange.magic.bottle.admin.modules.job.controller.ScheduleJobController.pause()', '[3]', 42, '223.104.64.157', '2019-10-20 23:26:22');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) CHARACTER SET utf8 DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'system', 3);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);
INSERT INTO `sys_menu` VALUES (6, 1, '定时任务', 'job/schedule', NULL, 1, 'job', 5);
INSERT INTO `sys_menu` VALUES (7, 6, '查看', NULL, 'sys:schedule:list,sys:schedule:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (8, 6, '新增', NULL, 'sys:schedule:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (9, 6, '修改', NULL, 'sys:schedule:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (10, 6, '删除', NULL, 'sys:schedule:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (11, 6, '暂停', NULL, 'sys:schedule:pause', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (12, 6, '恢复', NULL, 'sys:schedule:resume', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (13, 6, '立即执行', NULL, 'sys:schedule:run', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (14, 6, '日志列表', NULL, 'sys:schedule:log', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);
INSERT INTO `sys_menu` VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);
INSERT INTO `sys_menu` VALUES (31, 0, 'IM管理', NULL, NULL, 0, 'im', 1);
INSERT INTO `sys_menu` VALUES (32, 31, '标签', 'post/tag', NULL, 1, 'biaoqian', 0);
INSERT INTO `sys_menu` VALUES (33, 32, '查看', NULL, 'post:tag:list,post:tag:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (34, 32, '新增', NULL, 'post:tag:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (35, 32, '修改', NULL, 'post:tag:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (36, 32, '删除', NULL, 'post:tag:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (37, 31, '帖子', 'post/post', NULL, 1, 'post', 1);
INSERT INTO `sys_menu` VALUES (38, 37, '查看', NULL, 'post:post:list,post:post:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 37, '新增', NULL, 'post:post:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (40, 37, '修改', NULL, 'post:post:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 37, '删除', NULL, 'post:post:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (42, 0, '运营支持', NULL, NULL, 0, 'support', 2);
INSERT INTO `sys_menu` VALUES (43, 42, '敏感词', 'support/filter', NULL, 1, 'sensitiveWord', 0);
INSERT INTO `sys_menu` VALUES (44, 43, '查看', NULL, 'support:filterWord:list,support:filterWord:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (45, 43, '新增', NULL, 'support:filterWord:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (46, 43, '修改', NULL, 'support:filterWord:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (47, 43, '删除', NULL, 'support:filterWord:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (48, 42, '开屏广告', 'support/screen', NULL, 1, 'screenAd', 1);
INSERT INTO `sys_menu` VALUES (49, 48, '查看', NULL, 'support:screenad:list,support:screenad:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (50, 48, '新增', NULL, 'support:screenad:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (51, 48, '修改', NULL, 'support:screenad:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (52, 48, '删除', NULL, 'support:screenad:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (53, 0, '用户管理', NULL, NULL, 0, 'userManage', 0);
INSERT INTO `sys_menu` VALUES (54, 58, '查看', NULL, 'user:frontUser:list,user:frontUser:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (55, 58, '新增', NULL, 'user:frontUser:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (56, 58, '修改', NULL, 'user:frontUser:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (57, 58, '删除', NULL, 'user:frontUser:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (58, 53, '用户列表', 'user/frontUser', NULL, 1, 'frontUser', 6);
INSERT INTO `sys_menu` VALUES (59, 31, '会话列表', 'post/chat', NULL, 1, 'message', 2);
INSERT INTO `sys_menu` VALUES (60, 59, '查看', NULL, 'post:chat:list,post:chat:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (61, 59, '新增', NULL, 'post:chat:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (62, 59, '修改', NULL, 'post:chat:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (63, 59, '删除', NULL, 'post:chat:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (64, 42, 'App版本', '/support/version', NULL, 1, 'version', 2);
INSERT INTO `sys_menu` VALUES (65, 64, '查看', NULL, 'support:version:list,support:version:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (66, 64, '新增', NULL, 'support:version:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (67, 64, '修改', NULL, 'support:version:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (68, 64, '删除', NULL, 'support:version:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (69, 59, '消息列表', NULL, 'post:message:list', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (70, 42, '意见反馈', '/support/feedback', NULL, 1, 'bianji', 3);
INSERT INTO `sys_menu` VALUES (71, 70, '查看', NULL, 'support:feedback:list,support:feedback:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (72, 70, '新增', NULL, 'support:feedback:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (73, 70, '修改', NULL, 'support:feedback:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (74, 70, '删除', NULL, 'support:feedback:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (75, 42, '举报记录', 'support/tipofflog', NULL, 1, 'jubao', 4);
INSERT INTO `sys_menu` VALUES (77, 75, '查看', NULL, 'support:tipofflog:list,support:tipofflog:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (78, 75, '新增', NULL, 'support:tipofflog:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (79, 75, '修改', NULL, 'support:tipofflog:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (80, 75, '删除', NULL, 'support:tipofflog:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (81, 37, '帖子评论', NULL, 'post:postreply:list,post:postreply:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (82, 37, '帖子回复删除', NULL, 'post:postreply:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (83, 42, '举报统计', 'support/report', NULL, 1, 'zhedie', 11);
COMMIT;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COMMENT='文件上传';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '运营管理员', NULL, 1, '2018-06-24 15:55:55');
INSERT INTO `sys_role` VALUES (2, '运营人员', NULL, 1, '2018-08-04 23:18:32');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=422 DEFAULT CHARSET=utf8mb4 COMMENT='角色与菜单对应关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (270, 1, 1);
INSERT INTO `sys_role_menu` VALUES (271, 1, 2);
INSERT INTO `sys_role_menu` VALUES (272, 1, 15);
INSERT INTO `sys_role_menu` VALUES (273, 1, 16);
INSERT INTO `sys_role_menu` VALUES (274, 1, 17);
INSERT INTO `sys_role_menu` VALUES (275, 1, 18);
INSERT INTO `sys_role_menu` VALUES (276, 1, 3);
INSERT INTO `sys_role_menu` VALUES (277, 1, 19);
INSERT INTO `sys_role_menu` VALUES (278, 1, 20);
INSERT INTO `sys_role_menu` VALUES (279, 1, 21);
INSERT INTO `sys_role_menu` VALUES (280, 1, 22);
INSERT INTO `sys_role_menu` VALUES (281, 1, 4);
INSERT INTO `sys_role_menu` VALUES (282, 1, 23);
INSERT INTO `sys_role_menu` VALUES (283, 1, 24);
INSERT INTO `sys_role_menu` VALUES (284, 1, 25);
INSERT INTO `sys_role_menu` VALUES (285, 1, 26);
INSERT INTO `sys_role_menu` VALUES (286, 1, 6);
INSERT INTO `sys_role_menu` VALUES (287, 1, 7);
INSERT INTO `sys_role_menu` VALUES (288, 1, 8);
INSERT INTO `sys_role_menu` VALUES (289, 1, 9);
INSERT INTO `sys_role_menu` VALUES (290, 1, 10);
INSERT INTO `sys_role_menu` VALUES (291, 1, 11);
INSERT INTO `sys_role_menu` VALUES (292, 1, 12);
INSERT INTO `sys_role_menu` VALUES (293, 1, 13);
INSERT INTO `sys_role_menu` VALUES (294, 1, 14);
INSERT INTO `sys_role_menu` VALUES (295, 1, 27);
INSERT INTO `sys_role_menu` VALUES (296, 1, 29);
INSERT INTO `sys_role_menu` VALUES (297, 1, 30);
INSERT INTO `sys_role_menu` VALUES (298, 1, 31);
INSERT INTO `sys_role_menu` VALUES (299, 1, 32);
INSERT INTO `sys_role_menu` VALUES (300, 1, 33);
INSERT INTO `sys_role_menu` VALUES (301, 1, 34);
INSERT INTO `sys_role_menu` VALUES (302, 1, 35);
INSERT INTO `sys_role_menu` VALUES (303, 1, 36);
INSERT INTO `sys_role_menu` VALUES (304, 1, 37);
INSERT INTO `sys_role_menu` VALUES (305, 1, 38);
INSERT INTO `sys_role_menu` VALUES (306, 1, 39);
INSERT INTO `sys_role_menu` VALUES (307, 1, 40);
INSERT INTO `sys_role_menu` VALUES (308, 1, 41);
INSERT INTO `sys_role_menu` VALUES (309, 1, 81);
INSERT INTO `sys_role_menu` VALUES (310, 1, 82);
INSERT INTO `sys_role_menu` VALUES (311, 1, 59);
INSERT INTO `sys_role_menu` VALUES (312, 1, 60);
INSERT INTO `sys_role_menu` VALUES (313, 1, 61);
INSERT INTO `sys_role_menu` VALUES (314, 1, 62);
INSERT INTO `sys_role_menu` VALUES (315, 1, 63);
INSERT INTO `sys_role_menu` VALUES (316, 1, 69);
INSERT INTO `sys_role_menu` VALUES (317, 1, 42);
INSERT INTO `sys_role_menu` VALUES (318, 1, 43);
INSERT INTO `sys_role_menu` VALUES (319, 1, 44);
INSERT INTO `sys_role_menu` VALUES (320, 1, 45);
INSERT INTO `sys_role_menu` VALUES (321, 1, 46);
INSERT INTO `sys_role_menu` VALUES (322, 1, 47);
INSERT INTO `sys_role_menu` VALUES (323, 1, 48);
INSERT INTO `sys_role_menu` VALUES (324, 1, 49);
INSERT INTO `sys_role_menu` VALUES (325, 1, 50);
INSERT INTO `sys_role_menu` VALUES (326, 1, 51);
INSERT INTO `sys_role_menu` VALUES (327, 1, 52);
INSERT INTO `sys_role_menu` VALUES (328, 1, 64);
INSERT INTO `sys_role_menu` VALUES (329, 1, 65);
INSERT INTO `sys_role_menu` VALUES (330, 1, 66);
INSERT INTO `sys_role_menu` VALUES (331, 1, 67);
INSERT INTO `sys_role_menu` VALUES (332, 1, 68);
INSERT INTO `sys_role_menu` VALUES (333, 1, 70);
INSERT INTO `sys_role_menu` VALUES (334, 1, 71);
INSERT INTO `sys_role_menu` VALUES (335, 1, 72);
INSERT INTO `sys_role_menu` VALUES (336, 1, 73);
INSERT INTO `sys_role_menu` VALUES (337, 1, 74);
INSERT INTO `sys_role_menu` VALUES (338, 1, 75);
INSERT INTO `sys_role_menu` VALUES (339, 1, 77);
INSERT INTO `sys_role_menu` VALUES (340, 1, 78);
INSERT INTO `sys_role_menu` VALUES (341, 1, 79);
INSERT INTO `sys_role_menu` VALUES (342, 1, 80);
INSERT INTO `sys_role_menu` VALUES (343, 1, 83);
INSERT INTO `sys_role_menu` VALUES (344, 1, 53);
INSERT INTO `sys_role_menu` VALUES (345, 1, 58);
INSERT INTO `sys_role_menu` VALUES (346, 1, 54);
INSERT INTO `sys_role_menu` VALUES (347, 1, 55);
INSERT INTO `sys_role_menu` VALUES (348, 1, 56);
INSERT INTO `sys_role_menu` VALUES (349, 1, 57);
INSERT INTO `sys_role_menu` VALUES (350, 1, -666666);
INSERT INTO `sys_role_menu` VALUES (351, 2, 4);
INSERT INTO `sys_role_menu` VALUES (352, 2, 23);
INSERT INTO `sys_role_menu` VALUES (353, 2, 24);
INSERT INTO `sys_role_menu` VALUES (354, 2, 25);
INSERT INTO `sys_role_menu` VALUES (355, 2, 26);
INSERT INTO `sys_role_menu` VALUES (356, 2, 6);
INSERT INTO `sys_role_menu` VALUES (357, 2, 7);
INSERT INTO `sys_role_menu` VALUES (358, 2, 8);
INSERT INTO `sys_role_menu` VALUES (359, 2, 9);
INSERT INTO `sys_role_menu` VALUES (360, 2, 10);
INSERT INTO `sys_role_menu` VALUES (361, 2, 11);
INSERT INTO `sys_role_menu` VALUES (362, 2, 12);
INSERT INTO `sys_role_menu` VALUES (363, 2, 13);
INSERT INTO `sys_role_menu` VALUES (364, 2, 14);
INSERT INTO `sys_role_menu` VALUES (365, 2, 27);
INSERT INTO `sys_role_menu` VALUES (366, 2, 29);
INSERT INTO `sys_role_menu` VALUES (367, 2, 30);
INSERT INTO `sys_role_menu` VALUES (368, 2, 31);
INSERT INTO `sys_role_menu` VALUES (369, 2, 32);
INSERT INTO `sys_role_menu` VALUES (370, 2, 33);
INSERT INTO `sys_role_menu` VALUES (371, 2, 34);
INSERT INTO `sys_role_menu` VALUES (372, 2, 35);
INSERT INTO `sys_role_menu` VALUES (373, 2, 36);
INSERT INTO `sys_role_menu` VALUES (374, 2, 37);
INSERT INTO `sys_role_menu` VALUES (375, 2, 38);
INSERT INTO `sys_role_menu` VALUES (376, 2, 39);
INSERT INTO `sys_role_menu` VALUES (377, 2, 40);
INSERT INTO `sys_role_menu` VALUES (378, 2, 41);
INSERT INTO `sys_role_menu` VALUES (379, 2, 81);
INSERT INTO `sys_role_menu` VALUES (380, 2, 82);
INSERT INTO `sys_role_menu` VALUES (381, 2, 59);
INSERT INTO `sys_role_menu` VALUES (382, 2, 60);
INSERT INTO `sys_role_menu` VALUES (383, 2, 61);
INSERT INTO `sys_role_menu` VALUES (384, 2, 62);
INSERT INTO `sys_role_menu` VALUES (385, 2, 63);
INSERT INTO `sys_role_menu` VALUES (386, 2, 69);
INSERT INTO `sys_role_menu` VALUES (387, 2, 42);
INSERT INTO `sys_role_menu` VALUES (388, 2, 43);
INSERT INTO `sys_role_menu` VALUES (389, 2, 44);
INSERT INTO `sys_role_menu` VALUES (390, 2, 45);
INSERT INTO `sys_role_menu` VALUES (391, 2, 46);
INSERT INTO `sys_role_menu` VALUES (392, 2, 47);
INSERT INTO `sys_role_menu` VALUES (393, 2, 48);
INSERT INTO `sys_role_menu` VALUES (394, 2, 49);
INSERT INTO `sys_role_menu` VALUES (395, 2, 50);
INSERT INTO `sys_role_menu` VALUES (396, 2, 51);
INSERT INTO `sys_role_menu` VALUES (397, 2, 52);
INSERT INTO `sys_role_menu` VALUES (398, 2, 64);
INSERT INTO `sys_role_menu` VALUES (399, 2, 65);
INSERT INTO `sys_role_menu` VALUES (400, 2, 66);
INSERT INTO `sys_role_menu` VALUES (401, 2, 67);
INSERT INTO `sys_role_menu` VALUES (402, 2, 68);
INSERT INTO `sys_role_menu` VALUES (403, 2, 70);
INSERT INTO `sys_role_menu` VALUES (404, 2, 71);
INSERT INTO `sys_role_menu` VALUES (405, 2, 72);
INSERT INTO `sys_role_menu` VALUES (406, 2, 73);
INSERT INTO `sys_role_menu` VALUES (407, 2, 74);
INSERT INTO `sys_role_menu` VALUES (408, 2, 75);
INSERT INTO `sys_role_menu` VALUES (409, 2, 77);
INSERT INTO `sys_role_menu` VALUES (410, 2, 78);
INSERT INTO `sys_role_menu` VALUES (411, 2, 79);
INSERT INTO `sys_role_menu` VALUES (412, 2, 80);
INSERT INTO `sys_role_menu` VALUES (413, 2, 83);
INSERT INTO `sys_role_menu` VALUES (414, 2, 53);
INSERT INTO `sys_role_menu` VALUES (415, 2, 58);
INSERT INTO `sys_role_menu` VALUES (416, 2, 54);
INSERT INTO `sys_role_menu` VALUES (417, 2, 55);
INSERT INTO `sys_role_menu` VALUES (418, 2, 56);
INSERT INTO `sys_role_menu` VALUES (419, 2, 57);
INSERT INTO `sys_role_menu` VALUES (420, 2, -666666);
INSERT INTO `sys_role_menu` VALUES (421, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '盐',
  `email` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '9ec9750e709431dad22365cabc5c625482e574c74adaebba7dd02f1129e4ce1d', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', 1, 1, '2016-11-11 11:11:11');
INSERT INTO `sys_user` VALUES (2, 'kellen', 'a2bae0c7c9e010b0b177ce97273746e7e169327fc286b5492696fc4079ea2b74', 'R0Cupwf1nYcDdp3d13k3', '12345678@qq.com', '13249090143', 1, 1, '2018-06-24 15:55:33');
INSERT INTO `sys_user` VALUES (3, 'liulin', 'ec4be75dc560a0d141542fd15a73d0bc3f3984d8009f87dac620fec61c5bf352', 'wbO8XEvgNZOxPVVi2dYM', '404601519@qq.com', '15919962455', 1, 1, '2018-08-01 14:19:35');
INSERT INTO `sys_user` VALUES (4, 'hxiaolian', 'b4deb9fa985085c0b1a0f1fa9decda3f65b2f66ab6a6e75bb2b93328eeb169e9', 'GyE2d8XFJOzgZOIiJbTt', 'service@hxiaolian.com', '18814114118', 1, 1, '2018-08-02 16:17:54');
INSERT INTO `sys_user` VALUES (5, 'wuhaidong', '7f35108eb3e76ee00a6ad69dcecf7f768e98caa74dcfe96155a1a0ffa4512741', 'AorwvPvRydkmtMSBvlqa', '34985617@qq.com', '18676361048', 1, 1, '2018-08-04 23:19:20');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='用户与角色对应关系';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (2, 3, 1);
INSERT INTO `sys_user_role` VALUES (3, 2, 1);
INSERT INTO `sys_user_role` VALUES (5, 5, 2);
INSERT INTO `sys_user_role` VALUES (6, 4, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_token
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES (1, 'de99a58fbeef54d0c97b6f2b138d9ddf', '2019-10-28 09:22:18', '2019-10-21 09:22:18');
INSERT INTO `sys_user_token` VALUES (2, '85111de6c9e317fd3ff251adb5c64b17', '2018-08-08 22:51:12', '2018-08-01 22:51:12');
INSERT INTO `sys_user_token` VALUES (3, 'da4bf09568f5fd5386c981f2c55d6ade', '2019-04-06 22:00:22', '2019-03-30 22:00:22');
INSERT INTO `sys_user_token` VALUES (4, 'db145f5ccc8b1c3d05ab0b4718d89a3b', '2019-10-27 20:58:30', '2019-10-20 20:58:30');
COMMIT;

-- ----------------------------
-- Table structure for tag
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序字段',
  `tag_name` varchar(32) CHARACTER SET utf8 NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除 0否 1是',
  `tag_desc` text CHARACTER SET utf8 COMMENT '标签描述',
  `tag_ios_desc` text COMMENT 'ios标签描述',
  `tag_android_desc` text COMMENT 'android标签描述',
  `img_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '  是否可带图片  0是 1否',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COMMENT='标签表';

-- ----------------------------
-- Records of tag
-- ----------------------------
BEGIN;
INSERT INTO `tag` VALUES (-1, 0, '此刻', '2018-06-02 16:15:22', '2019-01-26 11:16:03', 0, '没人知道你是谁，吐露你此刻的心声吧…', '没有人知道你是谁，来吐露你此刻的心声吧…', '没有人知道你是谁，来吐露你此刻的心声吧…', 1);
INSERT INTO `tag` VALUES (1, 4, '沙雕', '2018-05-30 22:06:08', '2019-02-11 14:06:20', 0, '没人知道你是谁，来说说那些让你感到丧的事儿吧…', '来分享沙雕的人和事吧', '来分享沙雕的人和事吧', 1);
INSERT INTO `tag` VALUES (9, 5, '求助', '2018-06-29 15:32:03', '2019-01-26 11:16:28', 0, '没人知道你是谁，说说你的心愿吧…', '没有人知道你是谁，有什么问题就尽管问吧', '没有人知道你是谁，有什么问题就尽管问吧', 1);
INSERT INTO `tag` VALUES (14, 3, '吐槽', '2018-07-04 10:08:00', '2019-01-26 11:16:20', 0, NULL, '没人知道你是谁，在这里放肆吐槽吧…', '没人知道你是谁，在这里放肆吐槽吧…', 1);
INSERT INTO `tag` VALUES (15, 1, '秘密', '2018-08-11 09:15:52', '2019-01-02 09:52:29', 0, NULL, '没有人知道你是谁，内心有什么秘密就大胆说出来吧', '没有人知道你是谁，内心有什么秘密就大胆说出来吧', 1);
INSERT INTO `tag` VALUES (19, 2, '心愿', '2018-12-17 20:13:30', '2019-01-26 11:16:12', 0, NULL, '没人知道你是谁，来许一个愿望吧', '没人知道你是谁，来许一个愿望吧', 1);
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '用户名',
  `mobile` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '手机号',
  `password` varchar(64) CHARACTER SET utf8 DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
COMMIT;

-- ----------------------------
-- Table structure for tip_off_log
-- ----------------------------
DROP TABLE IF EXISTS `tip_off_log`;
CREATE TABLE `tip_off_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `item_id` bigint(20) NOT NULL COMMENT '举报目标id',
  `item_type` tinyint(1) NOT NULL COMMENT '举报目标类型  1：魔瓶 2：评论  3：对话',
  `to_user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '被举报人id',
  `user_id` bigint(20) NOT NULL COMMENT '举报人Id',
  `ip` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '举报人ip',
  `create_time` datetime NOT NULL COMMENT '举报时间',
  PRIMARY KEY (`id`),
  KEY `idx_to_uid` (`to_user_id`) USING BTREE,
  KEY `idx_create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67736 DEFAULT CHARSET=utf8mb4 COMMENT='举报记录表';

-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `topic_name` varchar(32) NOT NULL COMMENT '话题名称',
  `tag_id` int(11) NOT NULL COMMENT '标签id',
  `created_by` varchar(32) DEFAULT NULL,
  `updated_by` varchar(32) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `order_num` int(1) NOT NULL DEFAULT '1' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='话题表';

-- ----------------------------
-- Records of topic
-- ----------------------------
BEGIN;
INSERT INTO `topic` VALUES (18, '昨晚做了一个好梦', 3, 'system', 'system', '2018-10-24 15:24:32', '2018-10-24 15:24:32', 4);
INSERT INTO `topic` VALUES (22, '今天笑点就指望这张图了', 3, 'system', 'system', '2018-11-03 16:08:22', '2018-11-03 16:08:22', 1);
INSERT INTO `topic` VALUES (24, '做过最后悔的事', 15, 'system', 'system', '2018-11-03 16:20:00', '2018-11-03 16:20:00', 1);
INSERT INTO `topic` VALUES (25, '莫名笑喷的一句话', 3, 'system', 'system', '2018-11-03 16:27:30', '2018-11-03 16:27:30', 1);
INSERT INTO `topic` VALUES (26, '萌新报到', -1, 'system', 'system', '2018-11-03 16:30:29', '2018-11-03 16:30:29', 1);
INSERT INTO `topic` VALUES (27, '表情包get', 3, 'system', 'system', '2018-11-03 16:34:13', '2018-11-03 16:34:13', 1);
INSERT INTO `topic` VALUES (28, '那些单曲循环的歌', 17, 'system', 'system', '2018-11-03 16:38:34', '2018-11-03 16:38:34', 1);
INSERT INTO `topic` VALUES (33, '说不出口的爱恋', 15, 'system', 'system', '2018-11-03 17:24:16', '2018-11-03 17:24:16', 1);
INSERT INTO `topic` VALUES (35, '请教职场老司机', 9, 'system', 'system', '2018-11-03 17:40:05', '2018-11-03 17:40:05', 1);
INSERT INTO `topic` VALUES (36, '学生党的困惑', 9, 'system', 'system', '2018-11-03 17:40:05', '2018-11-03 17:40:05', 1);
INSERT INTO `topic` VALUES (37, '如何治愈抑郁', 9, 'system', 'system', '2018-11-03 17:41:45', '2018-11-03 17:41:45', 1);
INSERT INTO `topic` VALUES (38, '我身边奇葩的人或事', 14, 'system', 'system', '2018-11-03 17:43:11', '2018-11-03 17:43:11', 1);
INSERT INTO `topic` VALUES (39, '我的一件糗事', 15, 'system', 'system', '2018-11-03 17:47:32', '2018-11-03 17:47:32', 1);
INSERT INTO `topic` VALUES (41, '无处宣泄的小情绪', 14, 'system', 'system', '2018-11-03 17:51:45', '2018-11-03 17:51:45', 1);
INSERT INTO `topic` VALUES (42, '难于启齿的往事', 15, 'system', 'system', '2018-11-03 18:05:48', '2018-11-03 18:05:48', 1);
INSERT INTO `topic` VALUES (54, '最近撒的一次慌', 15, 'system', 'system', '2018-11-22 19:26:14', '2018-11-22 19:26:14', 1);
INSERT INTO `topic` VALUES (55, '你因为虚荣做过什么', 15, 'system', 'system', '2018-11-22 19:26:14', '2018-11-22 19:26:14', 1);
INSERT INTO `topic` VALUES (56, '最对不起的那个人', 15, 'system', 'system', '2018-11-22 19:26:14', '2018-11-22 19:26:14', 1);
INSERT INTO `topic` VALUES (57, '不敢告诉朋友的事', 15, 'system', 'system', '2018-11-22 19:26:14', '2018-11-22 19:26:14', 1);
INSERT INTO `topic` VALUES (62, '最想骂的人', 14, 'system', 'system', '2018-11-22 19:31:16', '2018-11-22 19:31:16', 1);
INSERT INTO `topic` VALUES (63, '感情困惑', 9, 'system', 'system', '2018-11-22 19:31:46', '2018-11-22 19:31:46', 1);
INSERT INTO `topic` VALUES (64, '家庭锁事', 9, 'system', 'system', '2018-11-22 19:31:46', '2018-11-22 19:31:46', 1);
INSERT INTO `topic` VALUES (66, '感情咨询', 15, 'system', 'system', '2018-11-22 19:32:34', '2018-11-22 19:32:34', 1);
INSERT INTO `topic` VALUES (67, '今天开森的事', 3, 'system', 'system', '2018-11-22 19:33:01', '2018-11-22 19:33:01', 1);
INSERT INTO `topic` VALUES (69, '手帐', 17, 'system', 'system', '2018-12-01 22:25:19', '2018-12-01 22:25:19', 1);
INSERT INTO `topic` VALUES (70, '游戏', 17, 'system', 'system', '2018-12-01 22:25:19', '2018-12-01 22:25:19', 1);
INSERT INTO `topic` VALUES (71, '真心求笔友', 17, 'system', 'system', '2018-12-01 22:25:19', '2018-12-01 22:25:19', 1);
INSERT INTO `topic` VALUES (72, '我的奋斗小目标', 17, 'system', 'system', '2018-12-01 22:25:19', '2018-12-01 22:25:19', 1);
INSERT INTO `topic` VALUES (73, '我的小自卑', 15, 'system', 'system', '2018-12-01 22:25:56', '2018-12-01 22:25:56', 1);
INSERT INTO `topic` VALUES (74, '不得不做的妥协', 14, 'system', 'system', '2018-12-01 22:27:07', '2018-12-01 22:27:07', 1);
INSERT INTO `topic` VALUES (75, '想家了', 14, 'system', 'system', '2018-12-01 22:27:07', '2018-12-01 22:27:07', 1);
INSERT INTO `topic` VALUES (76, '欺骗父母的一件事', 15, 'system', 'system', '2018-12-01 22:27:20', '2018-12-01 22:27:20', 1);
INSERT INTO `topic` VALUES (77, '不得不向现实低头', 15, 'system', 'system', '2018-12-05 19:49:26', '2018-12-05 19:49:26', 1);
INSERT INTO `topic` VALUES (78, '可怕的占有欲', 15, 'system', 'system', '2018-12-13 11:41:48', '2018-12-13 11:41:48', 1);
INSERT INTO `topic` VALUES (80, '一句话总结我的2018', -1, 'system', 'system', '2018-12-16 09:03:46', '2018-12-16 09:03:46', 1);
INSERT INTO `topic` VALUES (81, '内心深处的恶意', 15, 'system', 'system', '2018-12-16 10:56:01', '2018-12-16 10:56:01', 1);
INSERT INTO `topic` VALUES (88, '互相交换三个问题', 16, 'system', 'system', '2018-12-17 20:06:22', '2018-12-17 20:06:22', 1);
INSERT INTO `topic` VALUES (89, '写下你的坐标和心情', 16, 'system', 'system', '2018-12-17 20:06:22', '2018-12-17 20:06:22', 1);
INSERT INTO `topic` VALUES (90, '最想和TA分享的经历', 16, 'system', 'system', '2018-12-17 20:06:22', '2018-12-17 20:06:22', 1);
INSERT INTO `topic` VALUES (91, '我的恋爱观', 16, 'system', 'system', '2018-12-17 20:06:22', '2018-12-17 20:06:22', 1);
INSERT INTO `topic` VALUES (92, '想和恋人一起做的事', 19, 'system', 'system', '2018-12-17 20:14:57', '2018-12-17 20:14:57', 1);
INSERT INTO `topic` VALUES (93, '告诫自己的话', 19, 'system', 'system', '2018-12-17 20:14:57', '2018-12-17 20:14:57', 10);
INSERT INTO `topic` VALUES (94, '30岁之前要做的三件事', 19, 'system', 'system', '2018-12-17 20:14:57', '2018-12-17 20:14:57', 7);
INSERT INTO `topic` VALUES (95, '三年内希望做到的事', 19, 'system', 'system', '2018-12-17 20:14:57', '2018-12-17 20:14:57', 6);
INSERT INTO `topic` VALUES (96, '2019年的心愿单', 19, 'system', 'system', '2018-12-17 20:16:19', '2018-12-17 20:16:19', 3);
INSERT INTO `topic` VALUES (97, '最想见的名人或明星', 19, 'system', 'system', '2018-12-17 20:17:45', '2018-12-17 20:17:45', 4);
INSERT INTO `topic` VALUES (98, '20岁前要做的事', 19, 'system', 'system', '2018-12-17 20:17:45', '2018-12-17 20:17:45', 5);
INSERT INTO `topic` VALUES (99, '告白气球', 19, 'system', 'system', '2018-12-17 20:17:45', '2018-12-17 20:17:45', 8);
INSERT INTO `topic` VALUES (100, '这辈子一定要去的地方', 19, 'system', 'system', '2018-12-17 20:17:45', '2018-12-17 20:17:45', 2);
INSERT INTO `topic` VALUES (101, '我的沙雕日常', 1, 'system', 'system', '2019-02-11 14:05:59', '2019-02-11 14:05:59', 1);
INSERT INTO `topic` VALUES (102, '让人笑喷的沙雕台词', 1, 'system', 'system', '2019-02-11 14:05:59', '2019-02-11 14:05:59', 1);
INSERT INTO `topic` VALUES (103, '年度沙雕新闻', 1, 'system', 'system', '2019-02-11 14:05:59', '2019-02-11 14:05:59', 1);
INSERT INTO `topic` VALUES (104, '那些沙雕评论', 1, 'system', 'system', '2019-02-11 14:05:59', '2019-02-11 14:05:59', 1);
COMMIT;

-- ----------------------------
-- Table structure for up_log
-- ----------------------------
DROP TABLE IF EXISTS `up_log`;
CREATE TABLE `up_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `post_id` bigint(20) NOT NULL COMMENT '帖子id',
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未删除 1已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=174533 DEFAULT CHARSET=utf8mb4 COMMENT='点赞记录表';

-- ----------------------------
-- Records of up_log
-- ----------------------------
BEGIN;
INSERT INTO `up_log` VALUES (174532, 1186081770891845633, 1186074518315323394, NULL, '2019-10-21 08:51:01', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
